Performance issues in split PHP/MySQL installation
| From: | Gabor Szabo | Date: | Tue, 14 Sep 2004 11:25:40 +0000 |
| Subject: | Performance issues in split PHP/MySQL installation | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-24568@lists.php.net to get a copy of this message | ||
We are using PHP 5, Apache 1.3.x and MySQL on Windows.
Everything used to be on one server and the site seemed to work well.
For business reason we had to movethe MySQL database to another Windows
machine near-by. Since the move the time it takes to fetch a page
increased considerably.
As a first try I replaced the mysql_connect calls by mysql_pconnect.
It does not seem to make a difference.
So while I try to setup some bechmarking printouts I'd appreciate some
ideas how to find the problem and how to improve speed.
regards
Gabor
ps.
If I understand correctly on Windows there is only one Apache process,
and the thread created to serve the page is recycled immediately.
Based on this you cannot actually have persistent database connections
using Apache on Windows. Please correct me if I am mistaken.