Think about Loose Coupling | |
PerlMonks |
Re: faster with threads?by Abigail-II (Bishop) |
on Jun 09, 2004 at 13:13 UTC ( [id://362718]=note: print w/replies, xml ) | Need Help?? |
And if using a bulk insert isn't possible for some reason, first drop the indices on the table(s) involved, insert your data, then rebuild the indices. Unless the tables already contain billions of rows, rebuilding the indices is faster than modifying them millions of times.
Abigail
In Section
Seekers of Perl Wisdom
|
|