laziness, impatience, and hubris | |
PerlMonks |
Re: Database input speed questionby Mur (Pilgrim) |
on Jul 31, 2003 at 17:40 UTC ( [id://279682]=note: print w/replies, xml ) | Need Help?? |
If you are experiencing slowdowns on batch insert, one cross-DBMS solution is to drop the indexes on the table, do the inserts, and re-create the indexes. This almost always speeds things up, at the expense of giving up uniqueness (primary key) checks in some DBMS.
In Section
Seekers of Perl Wisdom
|
|