faster way to write tables?


I'm building a large lookup table by using an ADOCommand, repetetively setting the CommandText (and invoking Execute) in a loop for each row. The CommandText string looks something like:

SELECT INTO out_table (col1, col2, col3) VALUES (x1, x2, x3)

It works, but it groans a bit when there are ~50,000 records; I wouldn't want to use this method for one million records.

Is there something I can do to speed up output, like buffering the command strings to SQL Server?


.

Quantcast