Slow php-mysql

From: Date: Tue, 11 May 2004 17:39:12 +0000
Subject: Slow php-mysql
Groups: php.db 
Request: Send a blank email to php-db+get-34370@lists.php.net to get a copy of this message
Hi all, I recently change my apche, php mysql server for a better one. I installed all the same versions of software on the new server (except for php which was 4.36 RC2). I have apache 1.3 + mysql 3.23.58 + php 4.36. Im on a WinXp Pro os. I copy the exact config for the my.ini, httpd.conf and php.ini files. The result is unfortunatly a very slow application. For exemple, it takes 5-10 secoonds to phpMyAdmin to load after the login, but when a do a big query, with the query interface, it clocks under 1 second. I thought It was the php then, but a big while loop took not much time then normal to print out. Then maybe the apache, but page containing only HTML print well. I try to put a connection and disconnection in the While loop and it slow down all the process. With this little test I thing that it come from MySql. I try some setting like "output_buffering" without result. If someone can help me identify for sure the guilty process with some test a can't imagine myself.... Thanks, and sorry for my bad english I do my best! Drez

« previous php.db (#34370) next »