Marcin Debowski wrote:
I upgraded my old Fedora Core 5 server running mysql and php-mysql
from 5.022 and 5.1.6 to 5.075 and 5.2.6 respectively and performance
problems with accessing the databases appeared. I am not sure what
is the source but it seem to be rather related to php5-mysql than
the mysql engine itself.
This is how it shows up for a database of ~ 50k records:
Query: SELECT * FROM `zdjecie` WHERE 1 LIMIT 15000, 20000
1. The query executed via phpMyAdmin
FC5:
Takes ~0.4s to execute and ~4s to start displaying the records
U9.04:
Takes ~0.6s to execute and ~40s to start displaying the records.
Repeating the query SOMETIMES shorten this time to similar values
as for FC5 so it looks like it is sometimes buffered.
2. Same query from the shell level:
mysql -u user --password=xxx db < query > /dev/null
takes a fraction of the second for both setups.
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?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
