http://www.perlmonks.org?node_id=1043888


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

  • Comment on Re: Performance issues with inserting csv into SQL Server