|
|
Posted by Boris Stumm on 05/10/07 16:43
Ciaran wrote:
> 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?
I'd guess that a good DBMS can do it faster than you. I do not know that
much about MySQL, but with a decent optimizer and some indexes, the DBMS
will usually be faster. At least if it is not a completely strange query :)
Maybe you could define "compley query" (post the query here?), and define
what you mean with "lots of simple queries".
Navigation:
[Reply to this message]
|