narqelion wrote:If you are not getting memory allocation errors I would not worry about it.
That's how it started though... I first discovered there was a problem when PHP complained it was running out of memory so I assigned another chunk from 32Mb upto 64Mb. So that's fixed the symptoms of the problem, but in the long term what will happen if I leave it? 8sec and 64Mb to process a page - clearly something needs to be done now to address the issue.
I just want to get a clear picture of the situation, from an administrators point of view. What do I have to do to get the page processing time of 4 sec back down to below 1 sec? Do I throw more money at hosting, or is there something going on in the software SQL side of things that I don't know about?
Could it be any of the following
Fulltext native search backend
1,000 forums
35,000 posts
10,000 topics
The Apache status isn't showing any spikes in processor use relating to getting the page together, I'm not sure how to monitor the SQL side of things.
So in summary it's finding out why some pages take 4sec 30Mb to process, and that figure is increasing all the time. In a matter of months it'll be 6sec 40Mb etc... the forum is already sluggish so something needs doing now.
Thanks for any pointers you can offer.