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

[DESCHAMPS Stéphane DvSI/SICoR]

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...