Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-27 : 13:25:01
|
| Kenny writes "Hi, I just wrote my first stored procedure, and wanted to know how I can tell if I'm getting a performance improvement. I'm not really sure how I can tell.My code is written in Cold Fusion, and the query is below:insert into hits (date_of_hit, ip_address, page, UniqueUserId) values (getdate(), 'test', 'test', 'test')I'm mainly wondering if executing this as a stored procedure will be more efficient. It's called once on every page hit.Thanks for your time.Kenny(Using SQL 7 and Win NT 4.0, SP 5)" |
|
|
|
|
|
Performance difference between query and stored procedure