more useful options | |
PerlMonks |
comment on |
( [id://3333]=superdoc: 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 reply to Re^2: Optimizing mysql and inserts
by gossamer
|
|