How to increase bulk insert/select speed?
Posted on 1999-11-15
Today, I am writing a vc++ console application to insert 10000 records ,
totally 1x10E7 bytes, to mssql 7.0 server. Surprisely, the speed is
about 29Kbytes per second.
However, by ftp or copying the same
number of bytes to the server, i
got 2900Kbytes per second. A 100
I have chose "select into/bulk copy" in the database property. But no help.
Can I increase the speed of bulk insert
or bulk select from the server?
Or my program which using COM is slow?
my source code look like this :
m_pCommand->CommandText = "insert mytable values ('xxxxxx......') "
printf("duration is %2.1f",finish - start);