in reply to Re^4: Slow script: DBI, MySQL, or just too much data?
in thread Slow script: DBI, MySQL, or just too much data?

drop the indices, delete the columns, optimize the table, create the indices. You'll find a roughly 70% speedup.

My wife's blog

  • Comment on Re^5: Slow script: DBI, MySQL, or just too much data?

In Section Seekers of Perl Wisdom