efficiency qn:ado .AddNew VS INSERT in stored proc

ak · February 25th, 2004, 08:21 AM

Hi
(i have posted this in the database section..apologies for duplicate)
1. is the method below in example available to use in asp? if so is it more efficient for large number of inserts then using the INSERT statement in stored procedures?
example:
   With objADORS
     .AddNew
        .fields("BookTitle") = "Title"
        .fields("Publisher") = "Publisher"
        .fields("DateOfPurchase") = "DateOfPurchase"
     .Update
   End With

ak

pgtips · February 25th, 2004, 10:08 AM

I never use AddNew - its more resource intensive and slower than a direct SQL Insert.

Quote from Microsoft's "Platform SDK: Internet Information Services 5.1 - Data Access Performance" sums it up for me:

Quote:

quote:
To optimize performance, avoid using the ADO record addition and deletion methods, such as AddNew and Delete. If your application adds and deletes records intensively, your application will perform better if it uses direct SQL statements, such as INSERT.

rgds
Phil