Python, MS SQL, and batch inserts

Scott David Daniels Scott.Daniels at Acm.Org
Tue Apr 21 21:36:50 CEST 2009


Philip Semanchuk wrote:
> ... If you're doing a mass insert to populate a blank table it also often 
> helps to postpone index creation until after the table is populated....

I forget the name of the SQL Server bulk loader, but for large loads, I
used to populate a fresh table with the bulk data, then do UPDATEs and
INSERTs to get the data spread out into the main tables.  You (the OP)
might try a scheme like that.

--Scott David Daniels
Scott.Daniels at Acm.Org




More information about the Python-list mailing list