Feed Icon  


  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics


Open Source Projects



Updating thousands of records

Posted in Sql and Xml at Friday, May 14, 2004 2:21 AM Pacific Daylight Time

Dino Esposito asks How to update a few thousand records?

I hoped some hack was possible in 1.x to force a custom batch update size. My hope was for a private, internal property to set using reflection. No way. And in 2.0, the batch update implementation is significantly different and concatenates more statements into a SQL batch.

Have you tried with SQLXML updategrams? Any real-world feedback from large scale projects? 

This is something I plan on looking at real soon as one of the applications I'm working on will need to do some batch updating. Since the data I have is in a DataSet I was thinking of trying to use the SqlXml BulkLoader. If I come up with a SqlXml type solution I will be sure to post it as an article.

Friday, May 14, 2004 2:50:00 AM (Pacific Daylight Time, UTC-07:00)
>>This is something I plan on looking at real soon
<br>Will you be posting your results back to your blog? I'd love to see your findings (always looking for a faster way to bulk load data)
Comments are closed.