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

[Alan Kennedy]

[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