Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-04 : 07:22:12
|
| Jo writes "I'm writing a C program that inserts about 20 thousand records to the SQL Server 2000 every minute. Currently, I use the BULK INSERT statement to accomplish the job, but by doing this, I'm forced to create a data file every minute. To optimize my code, I would like to insert to the database straight from the memory. Is there anyway I can do this? I do not want to use INSERT INTO statement thousands of times because that will probably less efficient than BULK INSERT." |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-04 : 10:28:50
|
| If you don't save them as files, you will have to use the methods available in for example ADO, to insert the data. You could make some tests to see which method is the fastest. |
 |
|
|
|
|
|
bulk insert from memory