If you decide to use a prefix, then yes, usp versus sp makes a difference. SQL Server automatically searches the master database when sp_ is called. That can hurt performance.

Take a look at this article:

http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp