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

Alan Kennedy alanmk at hotmail.com
Fri Nov 11 17:30:25 CET 2005


[geskerrett at hotmail.com]
> I have a program that reads records from a binary file and loads them
> into an MS-SQL Server database.  It is using a stored proc, passing the
> parameters.

[snip]

> So my questions is ....
> Is there a "faster" method I can use to connect to the SQL server ?
> Or does anyone have any "optimization" tips the can offer ?

Is there a reason why you need to use a stored procedure?

Do you need to process the data in some way in order to maintain 
referential integrity of the database?

If the answer to both these questions is "no", then you can use the 
"bcp" (Bulk CoPy) utility to transfer data into SQLServer *very* quickly.

http://msdn.microsoft.com/library/en-us/coprompt/cp_bcp_61et.asp
http://www.sql-server-performance.com/bcp.asp

thought-it-was-worth-mentioning-ly y'rs,

-- 
alan kennedy
------------------------------------------------------
email alan:              http://xhaus.com/contact/alan



More information about the Python-list mailing list