0

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?

2
  • Do you really want IIS for this? There are preconfigured packages with Apache and php (even mysql) available.
    – cstamas
    Jul 24, 2012 at 19:04
  • IIS offers us a more manageable and scalable web server in our environment. We have 20 IIS servers working great. Just having this one issues at the moment. Across a few boxes.
    – JuanValdez
    Jul 24, 2012 at 21:18

2 Answers 2

0

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.

1
  • I think caching is outside the scope of the issue. Recycling the app pool on boot solves the issue. And seeing this is a dev box there is no apparent strain on resources to begin with. My goal is to find why/what on boot is causing the slow load, and why recycling the app pool fixes it.
    – JuanValdez
    Jul 24, 2012 at 21:20
0

After an upgrade to PHP 5.3.15 the issue seems resolved. I am not sure if a re-install of the old version would have fixed things.

I did notice on the effected server that 4 php-cgi.exe processes were running, and upon recycle only one would be spun up (fixeing the problem).

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .