Posted by David Gillen on 05/10/07 16:05

Ciaran said:
> Hi All,
> Is it faster to have mySql look up as much data as possible in one
> complex query or to have php do all the complex processing and submit
> lots of simple queries to the mysql database?
>
It was vary. Sometime a complex multijoin query with nested sub-queries may be
quicker, other times it will take far longer.
Alot will depend on how your database is setup in terms of normalisation and
indexes on tables etc.
Without doing independent tests yourself for both cases it is impossible to
know.

D.
--
Fermat was right.

[Back to original message]