Solved

IIS 7 PHP time to load issue

Posted on 2010-11-08
7
412 Views
Last Modified: 2012-05-10
Hello everyone,

First of all I have to say that I don't know much about WEB Servers so I will need detailed help :P

I have a Windows 2008 R1 x64 Server with IIS 7 in which I installed PHP using FastCGI which installed the version 5.2.14 of PHP.

Now I have the trouble that every form in PHP takes a long long time to load, overall if it makes calls to a local MySql Database.

Now the quiestions:
Is this a common problem?
Can be fixed?
if not, can I install an APACHE server with PHP and run PHP from there?

in advance, many thanks!
0
Comment
Question by:karelog
  • 5
7 Comments
 
LVL 3

Expert Comment

by:Chelcone
ID: 34085533
I use a program called AppServ (there are a lot of others like WinLamp or Xamp) to run PHP and Mysql on windows boxes, infact you only need an XP box to run it so it can be more cost effective. Im runing a CRM system for the company i workd for using this method.

Personaly i find this a lot easer than the nightmare os IIS and PHP coexisting.

Chelcone
0
 

Author Comment

by:karelog
ID: 34085596
The trouble is that I have a lot of apps using not only PHP but .NET Framework aswell.

so I can't run aspx forms from Apeche. I use IIS to run PHP because if I install apache I will have to run APACHE from a different port which can cause problems if a client try to load a page from apache from within a restricted network.
0
 

Author Comment

by:karelog
ID: 34085713
My team-mate tells me that the PHP worked just fine, except to HESK (http://www.hesk.com/). In HESK worked the admin part but not the ticket submit.

So my team-mate enabled the debugging in PHP. From that moment other apps in PHP stopped working (including HESK). He disabled the debugging but the damage was already dealt.

are some hidden options in IIS that could make this to happen?
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 13

Expert Comment

by:F Igor
ID: 34085780
Please Check or test if it's a PHP issue or a mysql connection issue:

Test a PHP page without db connections (for example, a phpinfo() page)
and compare with a simple page with db connecion and a simple query and data visualization.

IF only the db-connected page is slow, then you can check the host you are using to connect (prefer using the mysql IP if it's a DNS issue)
If all php pages are slow check the PHP.ini the configuration for "output_buffering"

Also ckeck the CPU usage during some page load  for the IIS (inetinfo) and Mysql processes
0
 

Author Comment

by:karelog
ID: 34085914
Hi fraigor, thanks for the reply.

The problem is for SOME applications.

We have about 10 PHP sites where in 3 of them PHP fails.
in 7 of the PHP app, all works perfect, db-connections (mysql and SQL Server).
in 3 of the PHP apps, nothing works.

you can try to load one of the 3 that fails:
http://www.liveprojects.cl/soporte1/ should load but it doesn't.

This is what that form should load:
http://146.155.105.169/soporte/
(this is a contingency that we applied in the meanwhile, it uses windows 2003 server)
0
 

Accepted Solution

by:
karelog earned 0 total points
ID: 34189123
I found the problem.

In some of the forms I had:

include "conectar.php"

and I had "conectar" in include path and at the same time in the specific application. This generated the error.

Thanks anyway!
0
 

Author Closing Comment

by:karelog
ID: 34221208
I solved the problem by myself
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now