[thelist] [best practices] Join queries in MySQL?

DESCHAMPS Stéphane DvSI/SICoR stephane.deschamps at francetelecom.com
Wed Nov 27 03:09:02 CST 2002

So to sum it up:

Both rudy and Ken say it's surprising to loop queries rather than do 'simple' join queries...

The senior PHP dev I'm talking about told me this two years ago, talking about a very very big database. He told me that JOIN queries would create temporary tables, thus disk accesses, thus slower rendering than a simple loop.

Anyway, until today I used his method... I'll have to look into JOIN queries then...

More information about the thelist mailing list