in reply to Re: mysql's join too slow; using Perl to compare two tables
in thread mysql's join too slow; using Perl to compare two tables

I don't know if this is because I didn't index the tables properly...

That's probably it. Proper indexing is essential with any non-trivial amount of data.

  • Comment on Re^2: mysql's join too slow; using Perl to compare two tables