Inserting Records into SQL Server - is there a faster interface than ADO

[Jarek Zgoda]

geskerrett at hotmail.com 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/