Bulk Insert

  • Thread starter Thread starter James Autry
  • Start date Start date
J

James Autry

I managed to get a performance boost from doing a batched INSERT SQL
Statement using ExecuteNonQuery rather than using the DataAdapter/Dataset
method for inserting multiple rows. I noted, however, that only so many
inserts could be batched before performance dropped again. Is this due to
server command queue cache size, or something like that?

Also, does anyone know when ADO 2.0 is supposed to come out?
 
James,
Make sure that you are executing your batch inside of a transaction, that
way the server will only commit the data once improving performance. Please
note that there may be backend limitations to the size and the number of
parameters of the batch, for example for Sql Server 2000 you can pass a max
of 2000 parameters and 250mb of data.

Sorry no information on when 2.0 will come out, have you tried the pdc
alpha? I would like to get some feedback on the Adapter batch update and on
SqlBulkCopy.

--
Angel Saenz-Badillos MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.
 
Back
Top