|
|
|
| Just another Perl shrine | |
| PerlMonks |
Re: Improving SQL speedby bart (Canon) |
| on Nov 01, 2009 at 22:19 UTC ( #804391=note: print w/replies, xml ) | Need Help?? |
|
You may look into using transactions, and only commit every N entries, or every M seconds, whichever is faster. You may find that slowness is largely caused by (implicit or explicit) commit for every insert.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||