Re: Bulk Insert
From: Angel Saenz-Badillos[MS] (angelsa_at_online.microsoft.com)
Date: 05/07/04
- Next message: Andy Gaskell: "Re: Howto SELECT for GUID values in a column."
- Previous message: RS: "Re: XSD"
- In reply to: James Autry: "Bulk Insert"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 May 2004 10:57:23 -0700
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. "James Autry" <j.m.autry@Austin.rr.com> wrote in message news:hEimc.68535$Dn1.46649@fe2.texas.rr.com... >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? > >
- Next message: Andy Gaskell: "Re: Howto SELECT for GUID values in a column."
- Previous message: RS: "Re: XSD"
- In reply to: James Autry: "Bulk Insert"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
