Inserting Records into SQL Server - is there a faster interfacethan ADO

[Scott David Daniels]

Alan Kennedy wrote:
> [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.
> 
>> 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,
> 
If the answer to some of the earlier questions is "yes," I have
found "bcp" can be a great tool to fill up a new table of data
"on its way in."  SQL can then move it to where it should really
go with nice transaction-protected SQL, proper index-building
and so on.  After distributing the data, you can drop the table
of pending data.

I agree this is off-topic, but it is too close to my experience.

--Scott David Daniels
scott.daniels at acm.org