PHPBB Speed Issues

--=-XHSw/0+Va4/1g76J3F6e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Guys,

I know this is maybe a bit specific for the general list, but thought
I'd throw it out there anyway as I reckon a lot of you have had
experience with PHPBB at some point or another. We've got an existing
installation of the forum here, that's been active for a couple of years
and is fairly busy. The site itself is on a dedicated server, but we're
having some issues with the speed. Some pages are taking â‰=857-8 secon=
ds to
display.

I've optimised the images in the template, enabled the GZ compression,
and it's only improved the speed by a mere fraction. I have noticed that
the page itself doesn't display until after this delay, so I was
guessing that I could maybe force the buffer to flush at key intervals
to give the impression the pages are loading faster. Does anybody have
any insights into this?

Thanks,
Ash
http://www.ashleysheridan.co.uk

--=-XHSw/0+Va4/1g76J3F6e--

Re: PHPBB Speed Issues

Ashley Sheridan wrote:
> I've optimised the images in the template, enabled the GZ compression,
> and it's only improved the speed by a mere fraction. I have noticed that
> the page itself doesn't display until after this delay, so I was
> guessing that I could maybe force the buffer to flush at key intervals
> to give the impression the pages are loading faster. Does anybody have
> any insights into this?

To bring things more on topic, why not rather have a discussion about
general scalability?

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
5. FINALLY, throw more hardware at it.

--
-- Paul

http://www.paulscott.za.net/
http://twitter.com/paulscott56
http://avoir.uwc.ac.za

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

Re: PHPBB Speed Issues

2009/7/31 Paul Scott :

-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.

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

Re: PHPBB Speed Issues

On Fri, 2009-07-31 at 11:27 +0100, David Otton wrote:
> 2009/7/31 Paul Scott :
>
> -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


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