Hi,
In a server farm, it depends on which machine has the lighter load, MySQL
or PHP.
If you are talking about running on the same machine, probably joining in
MySQL would be faster as it is optimized C code, while PHP is still running
in a virtual machine.
In general, benchmarks are the best
For now, probably more effective to run separate queries, in 4.1 mySQL
is supposed to include stored proc's at least for InnoDB tables, which
would be best of all... and is what I would like to see, in addition to
multiple query/recordset returns...
in MS-SQL/DB2/Oracle, i've created some