P is for Practical | |
PerlMonks |
Re: How to optimized mysql insert into tableby huck (Prior) |
on Jan 17, 2017 at 14:44 UTC ( [id://1179755]=note: print w/replies, xml ) | Need Help?? |
Are you running "$dbh->commit;" after every single insert(execute)? Thats where your problem would be. You need to batch up stuff before the commit. try inserting 1000 records then doing the commit.
In Section
Seekers of Perl Wisdom
|
|