Avoid the ADO AddNew and Delete Methods
Written by Eric Smith, Northstar Computer Systems LLC
If you’re looking to coax some performance from your application, be sure that you are using stored procedures or SQL statements to handle all your record additions and deletions. While you can use the AddNew and Delete methods of the ADO Recordset, they are quite a bit slower than the alternate versions that just use plain SQL or stored procedures. Stored procedures that do INSERT statements get additional performance since they have to update indexes when the new records are created. The execution plan includes this as part of the required work.
Keywords: [
Active Data Objects
|
ASP Performance
]
Publication Date: 5/1/2000, Last Update: 2/13/2010
|