Re^2: Optimizing mysql and inserts

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

Comment on Re^2: Optimizing mysql and inserts

Replies are listed 'Best First'.
Re^3: Optimizing mysql and inserts by huck (Prior) on Mar 15, 2017 at 02:47 UTC
I am surprised nobody ever mentioned `$rc = $dbh->begin_work; $rc = $dbh->commit;` [download] http://search.cpan.org/~timb/DBI-1.636/DBI.pm#commit Any time you work with more than a tiny few records you want to use begin_work and commit yea i know its old, and you probably know this by now	[reply] [d/l]
Re^3: Optimizing mysql and inserts by ruzam (Curate) on Jul 11, 2012 at 22:10 UTC
Not that it's Perl related, but what kind of differences did you find in the my.cnf file?	[reply]