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