Python, MS SQL, and batch inserts

Lawrence D'Oliveiro ldo at geek-central.gen.new_zealand
Thu Apr 23 05:02:11 EDT 2009


In message <mailman.4293.1240337749.11746.python-list at python.org>, Philip 
Semanchuk wrote:

> Are you sure your logjam is in Python? Inserting 5500 rows can take a
> few seconds if you're COMMITting after each INSERT. Wrap the whole
> thing in an explicit transaction and see if that helps.

Does MS-SQL have the equivalent of "insert delayed" 
<http://dev.mysql.com/doc/refman/5.0/en/insert-delayed.html>?




More information about the Python-list mailing list