Geeklog Forums

I have to uninstall and reinstall my forums, due to what I believe was a sloppy upgrade by myself, that has reduced speed to between 23 seconds - 150 seconds per page. My users are able to live with losing all the topics, but are concerned about their post counts. Is there any way to edit the post counts of users manually? I\'ve spent hours looking in my database, but just can\'t find it anywhere.

You really shouldn\'t need to delete any posts. You could always bulk copy them in again. Maybe you just need some more indexes on the files or some optimization of mysql. How many topics and posts do you have? Do you have a link?

It\'s at Scotsmanality.com, and there are over 30,000 posts right now, and 1400 topics.

The posts count is dynamic based on actual posts for that user id. There is no way to retain the posts counts and not the topics.

---

Geeklog components by PortalParts -- www.portalparts.com

So does this mean that if I delete any topics, it reduces the post count? Because I was thinking that the reason the forums are slow is because of so many topics, so was going to clean up...but that would mess up the post count?

I don\'t think the forum is necessarily slow because of number of topics. Though it probably could be tweaked some. It is probably more to do with layout. One topic created a 122 KB page, plus graphics. Pages that size are going to be slow. Table layouts unfortunately are slow. It would be interesting to see if any performance gain is made by using different themes. I will also do some search for other embedded forums and see if the response is any different.

- Yep, absolutly.

---

Geeklog components by PortalParts -- www.portalparts.com

I would add two indexes to the gl_forum_topics table. One on pid and one on uid. This should help speed, I don\'t know what kind of gain, but it should help. ALTER TABLE `gl_forum_topic` ADD INDEX `idxtopicuid` ( `uid` ) ALTER TABLE `gl_forum_topic` ADD INDEX `idxtopicpid` ( `pid` ) You might also be able to run mysqlcheck with some options to optimize the tables.

Thank you Dwight. Those two optimizations seemed to have speeded things up a bit, although its hard to judge how much, as I yelled at my hosts who have switched me to a better server so I\'m getting better speeds all around. Really appreciate your help, and if you find any more optimization methods, lemme know