Forum slower for anyone else?

5:46 am 2 registered 5 online. Found the rates at bottom of forum:
Generated in 20.439 seconds in which 19.467 seconds were spent on a total of 14 queries. Zlib compression disabled.
Then for message: much faster?
Generated in 0.523 seconds in which 0.069 seconds were spent on a total of 6 queries. Zlib compression disabled.
Whatever this means. Hope it helps.

Timbo: The numbers indicate that the server probably is overloaded at times. Some time it's the database backend that is slow, at other times it's the forum frontend that is slow.
E.g, my latest stats.
Generated in 12.99 seconds in which 0.013 seconds were spent on a total of 6 queries. Zlib compression disabled.
The database did its work fast, but the forum frontend which runs on the webserver (I suppose this forum runs on Apache and MySQL) used ~13 seconds to generate the page. Since it varies which subsystem is slow, I guess the server is bogged down doing something else. The question is what it is doing, as I dont see a influx of new users or increased activity.



Rick;
I don't think the problems were MySQL; I think it was UBB/PHP was the problem.
So the query was taking 0.683 seconds but the processing of the results took the other 5.3 seconds.
So the extra ram will (maybe) helping in 2 ways
1, The resultset can be kept in Ram.
2, PHP results / arrays can also be lkept in ram.
Overall good (so far)


Generated in 9.441 seconds in which 0.67 seconds were spent on a total of 13 queries. Zlib compression disabled.
As it varies which subsystem are slow, there must be a lack of resources. Doubling the RAM to 1GB has improved the performance as I experience the forums. There are lots of things that can be done to tune a server and further improve it, but I think we should leave it to the sysadmin and Rick until they ask for ideas and tips (the linux geek factor is probably quite high on this forum).
What I have noticed, is that many of the anonymous users are reading quite old threads. I suppose they either find these threads trough search engines, or they perform searches locally on the server. Free text searches, as I suppose they are implemented in this forum, with mysql as a backend, can be quite resource intensive.
Personally, I found that turning off "View user's pictures with their posts?" under "Display" settings improved the performance.
I find the forums quite usable now, even if Simon posted a horrendous time yesterday.

- 57 Forums
- 31.6 K Topics
- 345.9 K Posts
- 2,195 Online
- 31.1 K Members


