Ryfujk

What is better: yes / no radio, or simple checkbox?

Avoiding morning and evening handshakes

Counting monomials in skew-symmetric+diagonal matrices

How to properly claim credit for peer review?

Why is my solution for the partial pressures of two different gases incorrect?

How to approximate rolls for potions of healing using only d6's?

Yeshiva University RIETS Semicha Yorei and Yadin

Connecting top and bottom of adjacent circles

How would an AI self awareness kill switch work?

Can the Count of Monte Cristo's calculation of poison dosage be explained?

Why can I easily sing or whistle a tune I've just heard, but not as easily reproduce it on an instrument?

LTSpice: When running a linear AC simulation, how to view the voltage ratio between two voltages?

How to avoid being sexist when trying to employ someone to function in a very sexist environment?

Wanted: 5.25 floppy to usb adapter

How to define a macro with multiple optional parameters?

Why is c4 a better move in this position?

Metadata API deployments are failing in Spring '19

For Loop and Sum

Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?

Has the Isbell–Freyd criterion ever been used to check that a category is concretisable?

How do we edit a novel that's written by several people?

Why do neural networks need so many training examples to perform?

Where is this triangular-shaped space station from?

Inventor that creates machine that grabs man from future

Slow PHP Page Load on IIS7 until AppPool is Recycled

Very slow Apache on Windows 7Single web app, multiple web serverspage loading stops half-way, no server or sql loadWindows Server 2008 IIS7 - page requests randomly hang or timeoutPHP request sometimes very slowPHP Runs Very Slow on IIS7. Need Help optimizing our configConnecting to MySQL from PHP is extremely slowWebsite load perfectly from localhost but after 3 or 4 hours is not load from remote computer until restart iisdrupal on development machine slowPHP file load time, perhaps related to NFS?

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?

php iis-7 application-pools fcgi

share|improve this question

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

bumped to the homepage by Community♦ 12 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you really want IIS for this? There are preconfigured packages with Apache and php (even mysql) available.
  
  – cstamas
  Jul 24 '12 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 '12 at 21:18
  

  
  
  
  

add a comment | 

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?

php iis-7 application-pools fcgi

share|improve this question

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

bumped to the homepage by Community♦ 12 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you really want IIS for this? There are preconfigured packages with Apache and php (even mysql) available.
  
  – cstamas
  Jul 24 '12 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 '12 at 21:18
  

  
  
  
  

add a comment | 

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?

php iis-7 application-pools fcgi

share|improve this question

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

share|improve this question

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

share|improve this question

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

asked Jul 24 '12 at 18:40

JuanValdezJuanValdez

165

2 Answers
2

active

oldest

votes

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.

share|improve this answer

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

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 '12 at 21:20
  

  
  
  
  

add a comment | 

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).

share|improve this answer

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f410777%2fslow-php-page-load-on-iis7-until-apppool-is-recycled%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

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.

share|improve this answer

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

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 '12 at 21:20
  

  
  
  
  

add a comment | 

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.

share|improve this answer

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

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 '12 at 21:20
  

  
  
  
  

add a comment | 

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.

share|improve this answer

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

1

share|improve this answer

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

1

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

edited Jul 24 '12 at 20:19

sysadmin1138♦

117k17145280

answered Jul 24 '12 at 20:17

amroesamamroesam

1

answered Jul 24 '12 at 20:17

amroesamamroesam

1

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).

share|improve this answer

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

add a comment | 

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).

share|improve this answer

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

add a comment | 

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).

share|improve this answer

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

share|improve this answer

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165

answered Jul 25 '12 at 15:35

JuanValdezJuanValdez

165