Re: slow mysql queries via php5-mysql

Marcin Debowski wrote:

On 2009-07-30, Chris <dmagick@gmail.com> 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/