February 23, 2003 at 6:18 pm
Hi Everyone, one of our ASP developers came to me stating we should put all Inserts into store procs and I was wondering is there a performance gain by doing this or anything else gained by doing this?
Thanks
February 24, 2003 at 7:47 am
Not a huge gain, but it's the right thing to do. All data access with the possible exception of search type queries that would require dynamic sql should go in stored procs.
Andy
March 16, 2003 at 9:14 am
Should be a slight performance gain.
But a huge gain in flexibility, security, maintenance, debugging, ...
(if all access is via SPs).
Cursors never.
DTS - only when needed and never to control.
March 17, 2003 at 3:17 am
The big security factor is that you grant execuion rights to the SP and as long as the ownership chain is the same you do not have to grant any access o the underlying table. That is the biggest gain.
Next is the fact you can tweak things with limited impact on the ASP as needed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply