|
Posted by Roman on 05/14/07 03:10
Ciaran wrote:
> 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?
>
> Cheers,
> Ciarán
>
I would vote for single complex query over multiple queries with
sub-results being processed by PHP.
Do not forget that SQL is a procedural language and you can also write
algorithms in it (I am not 100% sure about MySQL though). Any PHP to
MySQL interraction will have an interprocess overhead (on same server)
or network communication overhead (MySQL hosted on different server).
Roman
Navigation:
[Reply to this message]
|