Re: slow mysql queries via php5-mysql
| From: | Marcin Debowski | Date: | Thu, 30 Jul 2009 03:41:12 +0000 |
| Subject: | Re: slow mysql queries via php5-mysql | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46363@lists.php.net to get a copy of this message | ||
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.
--
Marcin