Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 08:21 am EDT

Geeklog Forums

Forum - Editing post count manually?


Scots

Anonymous
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.
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
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?
 Quote

Scotsman

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

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote

Scotsman

Anonymous
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?
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
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.
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
Quote by Scotsman: So does this mean that if I delete any topics, it reduces the post count?
- Yep, absolutly.
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
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.
 Quote

Scotsman

Anonymous
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 Big Grin
 Quote

All times are EDT. The time is now 08:21 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content