Php – Slow PHP Page Load on IIS7 until AppPool is Recycled

application-poolsfcgiiis-7PHP

Using PHP 5.3.13 and MySQL 5.5.25 on Server 2008 R2 (IIS 7.5).

I have a PHP page that pull some info from MySQL and outputs some XML. The page works fine, and takes about 5 seconds to load a very small array when the server is first booted up.

However, when I recycle the app pool for the site it begins to load instantly. If I reboot the server it loads slow again until I manually recycle the app pool.

Any ideas?

Best Answer

What about caching your query to reduce the time for execution, or what about recoding the query or adding index for mysql table it's that will be the best result yet.

Related Solutions

Php – Very slow Apache on Windows 7

You might find apache serves php faster with the module, rather than the cgi..

LoadModule php5_module "c:/php/php5apache2_2.dll"

Rather than:

AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php-cgi.exe"

Is it only PHP & generated JS that is slow? What if the JS is static, does that load normally?

Mysql – PHP request sometimes very slow

It's difficult to pinpoint the exact cause of a slow performing server from just a brief description, you're going to want to do some benchmarking to target the cause of the slow down. For example...

It could be apache's configuration (max clients could be set to a really low number - this is doubtful however). Try apache benchmark (ab)
It could be poorly constructed MySQL queries causing table locks (depending on your storage engine for each table accessed) or the MySQL connection limit being really low (check this)
It could be that your PHP scripts are really intense, and your server just doesn't have the hardware to support that level of activity.
EDIT: Take a look at munin which will give you a comprehensive overview of your server performance, then monitor it as you make the requests.

It's all very subjective. Maybe someone else could point out some other potential issues.

Best Answer

Related Solutions

Php – Very slow Apache on Windows 7

Mysql – PHP request sometimes very slow

Related Topic