in reply to Performance issues with inserting csv into SQL Server
what is your underlying table,is it a BTREE? do you have an index on it ? do you allow duplicate values?
it might be worth to check modifying the table into a heap which will drop the indexes so the rows will get inserted much faster, and then modify it back to the original structure/re-enable the dropped indexes
|
---|
In Section
Seekers of Perl Wisdom