Website Performance Tips for PHP / IIS / MySQL

The PHP website I inherited running on IIS is very slow. I started looking into the issue and found out the original developer did not believe in indexes. I captured the sql statements and ran them through EXPLAIN to see if they were hitting anything. Performance increased after adding some indices.

Besides indices, are there some basic things I can do to increase website performance for PHP, IIS or MySQL?

You can try installing win-cache…

http://www.iis.net/downloads/microsoft/wincache-extension

Phphelp.com and mlbboards.com are both php sites running on IIS.

That would make me really nervous about what else he/she did not believe in…

That would make me really nervous about what else he/she did not believe in...
I'll give you another tidbit. The developer didn't fully believe in database normalization.

Imagine a simple order system. I would create (at a bare minimum) a client table and a order table. The original developer created a client table and one order table for every new order. I am currently at 1,500 tables in my database I inherited. :o

You can try installing win-cache..
Thanks Topcoder. This looks like an easy enhancement.
Sponsor our Newsletter | Privacy Policy | Terms of Service