On Fri, 2009-07-31 at 11:27 +0100, David Otton wrote:
> 2009/7/31 Paul Scott <psc...@uwc.ac.za>:
> -1. Measure everything. No point implementing a change that slows
> things down. Implement low-hanging-fruit first (eg a CDN)
> 0. Optimise your existing setup before adding more layers
> > 1. Cache as much as you can (everything)
> > 2. Minimise HTTP requests
> > 3. Use an opcode cache like APC
> > 4. Use a RAM based cache system like memcacheD and give your db a breather
> 4a. Cache complete objects, not DB result sets
> 5. Don't tie up Apache processes with requests for static files
> (lighttpd/CDN/both)
> > 6. FINALLY, throw more hardware at it.

For those interested, I found the errant cause of the speed issue. Was a
query using a left join on 4 of the largest tables. Changed one query to
an inner join, and it's now smoking again!


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to