Posted on: 09/23/03 05:47pm
By: Anonymous (Scots)
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.
Re:Forum - Editing post count manually?
Posted on: 09/23/03 06:36pm
By: DTrumbower
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?
Re:Forum - Editing post count manually?
Posted on: 09/23/03 06:55pm
By: Anonymous (Scotsman)
It\'s at Scotsmanality.com, and there are over 30,000 posts right now, and 1400 topics.
Re:Forum - Editing post count manually?
Posted on: 09/23/03 08:53pm
By: Blaine
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.
Re:Forum - Editing post count manually?
Posted on: 09/23/03 10:01pm
By: Anonymous (Scotsman)
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?
Re:Forum - Editing post count manually?
Posted on: 09/23/03 11:16pm
By: DTrumbower
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.
Re:Forum - Editing post count manually?
Posted on: 09/23/03 11:45pm
By: Blaine
[QUOTE BY= Scotsman] So does this mean that if I delete any topics, it reduces the post count? [/QUOTE]
- Yep, absolutly.
Re:Forum - Editing post count manually?
Posted on: 09/24/03 01:27am
By: DTrumbower
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.
Re:Forum - Editing post count manually?
Posted on: 09/24/03 07:06pm
By: Anonymous (Scotsman)
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