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.