Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Windows Hosting : Help with improving performance on IIS - PHP and MySQL Apps

[pgowder]

I'm having some performance issues on IIS with my PHP and MySQL applications. I'm also starting to see some errors.

One of my main apps is vBulletin. I've tried posting there for help, but not many people there have experience with IIS.

See this thread:
http://www.vbulletin.com/forum/showthread.php?t=243495

Can anyone here help?

Thanks!

[gate2vn]

If you're using PHP with mySQL, why do you choose Windows/IIS? I always prefer *nix platform for PHP/mySQL application

[pgowder]

Originally Posted by gate2vn

If you're using PHP with mySQL, why do you choose Windows/IIS? I always prefer *nix platform for PHP/mySQL application

Because I have applications that only run on a Windows/IIS server.

[AI_CharlieL]

Here's my little personal joomla site: http://shockadvised.net

This is completely running on Windows 2003/IIS6 with mySQL5 and PHP5 (although mySQL 4 and PHP4 produce identical results). In my opinion this is pretty quick. At one time, we had issues with the site running slow, and it turned out after a few days of trying to figure it out, that it was a disk I/O intense program running (real-time virus scanning) causing php/mySQL sites more than ASP.net sites to run like molasses. I would make sure nothing is hitting disk I/O too hard in task manager.

[NeiSep]

there is some tools for tweak IIS to make better preformance but i wouldn't think that would work.
The best thing is to have good hardware and then to configure it pretty good then you should be ready and done.

[plumsauce]

Are you running PHP as an isapi?

I would also look at running SQL Express instead of mysql.

[pgowder]

Originally Posted by plumsauce

Are you running PHP as an isapi?

I would also look at running SQL Express instead of mysql.

Yes as ISAPI.

The apps I'm using require MySQL.

[AI_CharlieL]

Ok, well, what sort of errors have you seen? "CGI Misbehaved" error?

Is this running on a dedicated mySQL server? Is it a slammed box? I really think disk I/O might be your culprit. mySQL/PHP should run decent out of the box with IIS.

[mjb-is]

Running PHP as ISAPI is renowned for instability on Windows.

Your best bet is to run FastCGI using the Microsoft implementation at http://www.iis.net/default.aspx?tabid=1000051

This will give you the speed of ISAPI with the stability of CGI.