responsiveness

Topics: User Forum
Jun 1, 2006 at 11:44 AM
Just a quick question. I've got a perception that displaying the discussion group home page seems to be quite a bit slower than it was yesterday.

Refreshing the home page a few times shows the following timings at the bottom of the page:- 7.643 seconds, 7.704 seconds, 7.707 seconds, 7.605 seconds, 7.695 seconds.

I was wondering if the more info there is, the slower it will go? Here are the current stats for our discussion groups:-

There are 119 posts in 39 topics in 33 forums.
We have 19 registered members.

Any thoughts?
Jun 1, 2006 at 2:29 PM
We are now just over 8 seconds to display the home page, with the following stats:-
There are 127 posts in 40 topics in 33 forums.
We have 19 registered members.

However, if I go to the admin, forums page, which is almost the same, it displays in 0.167 seconds.

I think it is something to do with all the 'select count * from .... where forum=forumid ' and 'select top 1 from ..... where forum=forumid order by date desc' to display the number of topics, posts and the last post for each forum.