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

rudy r937 at interlog.com
Tue Nov 26 12:33:01 CST 2002


stef, i don't actually have php/mysql to test with, so i can only guess

however, i would be really curious to see if your so-called "senior"
php/mysql guy actually ran any tests himself (and if he did, what version of
mysql he was using)

my gut instinct tells me he's wrong -- very very wrong -- to suggest that
calling the database repetitively from inside a loop is going to be faster
than a join

maybe he just likes the php side, you know, in love with his own coding, and
resents the fact that a database join query makes it unnecessary?

i would love to have somebody actually run some timings on this


rudy




More information about the thelist mailing list