Re: Is this the most effient to do with php an mysql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Paul Goepfert schrieb:
> Is there a more efficient way to do this using more PHP and less mysql?

Anything that helps you inside SQL to get your solution doing just one
statement should be faster than doing two queries with some PHP code
inbetween for "reasonable complicated" tasks. This is because the time
overheads for using the connection and the socket overhead are bigger
than the time won by doing the intermediate calculation "a bit" better
with PHP.

So, if your SQL looks somehow similar to what you would do on the PHP
side: Keep it that way!

OLLi

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux