Re: PHPBB Speed Issues

On Fri, 2009-07-31 at 11:27 +0100, David Otton wrote: > 2009/7/31 Paul Scott <pscott@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! Thanks, Ash http://www.ashleysheridan.co.uk