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