[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