No such thing as a small change | |
PerlMonks |
Re: mysql's join too slow; using Perl to compare two tablesby monarch (Priest) |
on Feb 04, 2006 at 22:59 UTC ( [id://528009]=note: print w/replies, xml ) | Need Help?? |
I have personally found myself somewhat disgusted with MySQL performance when it comes to simple joins. I don't know if this is because I didn't index the tables properly of some inherent disability in MySQL.
Postgres, on the other hand, seems to take the same time to do inner, outer, or whatever style joins with no performance penalty. So, no, it's not wrong to scan each table one at a time and getting perl to do the intelligent work with MySQL.
In Section
Seekers of Perl Wisdom
|
|