The stupid question is the question not asked | |
PerlMonks |
Re: Performance issues with inserting csv into SQL Serverby nikosv (Deacon) |
on Jul 12, 2013 at 06:56 UTC ( [id://1043888]=note: print w/replies, xml ) | Need Help?? |
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
|
|