[EMAIL PROTECTED] napisaĆ(a): > Is there a "faster" method I can use to connect to the SQL server ? > Or does anyone have any "optimization" tips the can offer ?
This has nothing with python, but the fastest way to load large amount of data to MS SQL Server database is DTS import from flat file. To spped up the things a bit, do not commit transaction after each row inserted -- commit whole batch. -- Jarek Zgoda http://jpa.berlios.de/ -- http://mail.python.org/mailman/listinfo/python-list