Re^5: Need faster MySql data fetching with perl DBI

To add to beable's answer, make sure that the columns you're joining together are the EXACT same datatype, down to the size. Otherwise, MySQL will make very expensive conversions, slowing your query down considerably. (In one of my tests, a 10second query didn't finish in 4 hours.)

Always read the docs for something you plan on basing your application on. Why do people assume that complex applications like RDBMS's can simply be loaded up and they'll work perfectly the first time?!?

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

I shouldn't have to say this, but any code, unless otherwise stated, is untested

Comment on Re^5: Need faster MySql data fetching with perl DBI