Marcin Debowski wrote:
On 2009-07-30, Chris <dmagick@xxxxxxxxx> wrote:
So all the time is spent travelling back to the 'client' (phpmyadmin)
and processing those results.
The php-mysql bridge isn't very complicated, I doubt it's going to cause
these sort of delays. I would suspect phpmyadmin purely because it has
to process 50,000 rows, work out paging, display them, and so on.
Is phpmyadmin on the same server as mysql?
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.
Or do you have a cli script you can run to do the same thing?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
