[lazytown]

Sorry, I didn't mean to be rude in any way at all. Didn't mean to "spank you" at all. Your efforts are greatly appreciated and I was really looking for something like this. In fact I really love this mod. I just wanted to be honest to the rest of the users. I think it's very important that we examine that aspect of each mod on large forums. This one just happened to place the largest load I've ever seen out of over 50 mods I've tried/installed. I thought the warning was warranted. I don't make a habit out of it.

I wouldn't be presumptuous to tell you how you need to modify it in order to make it work "properly." Right now it does seem to work properly -- and on small forums with load to spare, I think it's fine.

I actually didn't think it would be that easy to change the mod to create a separate table. It would be a much larger hack. I'm not sure we are talking about the same thing. In order to make it truly efficient, a permanent table would have to be added to the database that gets updated with every post a user makes (very slight load increase for posting). This table would then be used by the mod and create almost no load upon viewing threads. There would have to be an initial post scan upon install to create the counts for each user (and possibly something that could be run separately in the future). That would be a very long query (scanning all posts for all users), but only run one time at install. As a bonus, something like that could make it easy to show how many posts a user has in each forum anywhere on the site (like in member profile, etc). If you did that, I would definitely use it and give you huge props.

How many total posts do you have in your forum? That will make an enormous difference on the server load this plugin adds. The load placed by the mod will grow as the posts grow.

My forum has about 1M posts and 11K members. On that size of a forum, this did double the time per page and I tested it several times when there was almost no one on the board. Since it scans the entire posts table for each and every post (10X per page) , it's easy to see how that load is placed.

Sincerely
-vissa

Originally Posted by calorie

Thanks for the warning, but on my board this mod does not substantially increase server load or page display time (see attached screenshots) and that is probably true for some others also. While it wouldn't be hard for me to utilize a separate table and add a left join in the post query, the total overhead on my board is negligible either way, so the mod was created using separate count queries.

Something to remember is that my mods get tested on my board. It's rather off-putting to be spanked when it's not possible for me to test on your board, his board, her board. If you would have said something like, "Neat mod but would it be possible to do X instead of Y because Z happens?" I'd have been more inclined to redo the mod to help out, even though I don't need such a redo on my board.