March 14, 2003 at 8:14 am
Which is better for single-table or multiple-table updates, a stored procedure or ADO recordset objects (Begintrans, Add, Update, etc.), assuming any new values are computed client-side? This situation is such that one or just a few records are updated. Perhaps the answer cannot be generalized?
Thanks for any pointers.
March 14, 2003 at 1:01 pm
On average you will find Stored Procedures faster and more flexiable. The primary reason is some business logic can be there requiring less work if client is an executable to make minor tweaks. The other is stored execution plans. However, no guarantees a condition doesn't exist where that is unture. Also, Dynamic SQL where the query will changes conditions often is not for the most part any better in an SP.
March 14, 2003 at 1:24 pm
As always in our wonderful world of programming, ... it depends 🙂
This is an EXCELLENT resource article that will address many of your questions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetarch13.asp
Edited by - jpipes on 03/14/2003 1:28:03 PM
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply