[lazytown]

Sounds like a good attempt at reducing the queries. I'll give it a whirl, though I am still very weary of having the entire post table scanned in each thread (this time only once instead of 10 times, but it's still a very big query). I'll let you know how the load changes with the mods you've done. Thanks!

-vissa

Originally Posted by calorie

I'm all for honesty, but that post, maybe I just took it wrong, so I apologize too. Personally I think the utilization of a separate table wouldn't be hard, for me or anyone really, though I do agree that it'd be tedious to find all the spots for updates. That tedium, and the part about inserting the initial counts on a board of your size, got me to thinking. What I came up with is two queries in showthread, one should be negligible on any board, and for the other, I simply don't know how it'd be on a board with a 1M posts and 11K members. I believed you when you initially said that your load time doubled; I just don't have a board of that size for tests. If you saw a ten percent load time increase per post, maybe now you'll see a ten percent load time increase overall, but I really can't say for sure. Maybe you'll let me know?