[geeklog-users] geeklog performance

[Tony Bibbs]

Most of the load is, undoubtedly, on the database.  Do you have MySQL's 
query cache feature enabled and optimally configured?  I'd start there.  
I'd also strongly encourage using a php accelerator like APC:

http://pecl.php.net/package/APC

I'm hoping you aren't doing either of those yet and if that is the case 
you can expect significant improvements from both.

FWIW my site, http://www.iowaoutdoors.org is averaging around 1.5 load 
times on the homepage and significantly worse in the forums.  Only thing 
I have going for me is a fast pipe to the server.  Performance is going 
to continue to be an issue in the foreseeable future.

--Tony

Robin Bowes wrote:

> Hi,
>
> I wonder if anyone could help me out with a performance problem I'm 
> having with my geeklog site (http://robinbowes.com)?
>
> According to the timing at the bottom of the page, the front page 
> takes between 1.5-2 seconds to create, which I think is rather slow. 
> Some topic pages load in around 0.5/0.6 seconds, but I think even that 
> is a little slow.
>
> The box is a dual CPI PIII with 1.5GB RAM.
> Storage is software RAID created from 6x250GB SATA drives.
> System is Fedora Core 3, with apache 2.0.52, php 4.3.9, mysql 4.1.7.
> geeklog is latest from CVS as of about 1 hour ago.
>
> Load average is barely above 0.0, 375MB RAM is used (excluding cache 
> and buffers).
>
> I've tried disabling plugins (RDF blocks, images, etc) but that didn't 
> seem to make much difference.
>
> Any sugestions?
>
> R.