Marcin Debowski wrote:
On 2009-07-30, Chris <dmagick@xxxxxxxxx> wrote:
Marcin Debowski wrote:
Yes, but I daubt phpmyadmin is the culprit - a dedicated web interface I
have written for the database has exactly the same problem. This
interface works fast under the old version of php-/mysql and slow under
the new one. The php code is the same.
Can you run it on the same server as a test? That will rule out whether
it's network related at least.
Mysql and apache are on the same physical server but it connects via
127.0.0.1.
So it's not network related, I thought they may have been different
physical machines.
Or do you have a cli script you can run to do the same thing?
I just tried to connect via the socket and I am not sure if this helped
- seems slightly better but this could be sheer effect of the different
connection route. I will try to run some more quantitative tests.
That suggestion was to see if cutting phpmyadmin out of the picture made
a difference rather than testing the network theory.
Plus, mysql_query buffers the results before sending them back to the
client - which means mysql loads 50,000 records in to memory, then sends
it to php.
Are there any differences in (say) memory_limit settings for the two php
setups, or any of the mysql specific settings in php.ini ?
If you use an unbuffered query, does it make a difference
(http://www.php.net/manual/en/function.mysql-unbuffered-query.php) ?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
