Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re^2: Optimizing mysql and insertsby gossamer (Sexton) |
on Jul 11, 2012 at 19:51 UTC ( [id://981241]=note: print w/replies, xml ) | Need Help?? |
I've commented out the "$dbh->do($sql);" in my code, and it's substantially faster. That is definitely the bottleneck. ...few minutes later, after a few trial runs... I grabbed a my.cnf from a larger server and put it in place of the existing one, and it's magnitudes faster! Turns out it was in how mysql was configured. I think it's much better now. I'm actually pretty proud of myself for this, and thanks for everyone's help as well! Thanks,Alex
In Section
Seekers of Perl Wisdom
|
|