As papster described above, to display the home page (latest posts), the code grabs the latest n threads and then grabs all of the posts for all of those threads.
This is done just to display the list of threads where the posts inside the thread are not even visible.
This happens every time someone refreshes the home page. Add Optimus trousers’ mammoth ~300 page thread into that and the server is thrashing on every F5.
The reason seems to be down to a desire show summary stats next to the thread that come from the posts.
It’s either very poor design, or as papster suggested, we’re using the forum in a way that was not intended/envisaged.
Re: horses for courses…Yep. I was just yanking your tail.
I think we’re alright on site performance now. Back up to 20 topics on Latest Topics. Still flying like shit off a shovel. Optimus Trousers has been reactivated. Bletch, can we close this bastard?
I think it might be a good thread to keep pulling back to the top if anyone has concerns about site performance, and wants to answer the “Is it just me?” question.
I keep beating away, but I just can’t get a woody. Maybe the site needs a tesosterone injection? Maybe some pics of booblies. Hey! I’m just trying to be helpful!!
I have been noticing an issue with thread load times. They seem to have been getting progressively worse for me. In my capacity as admin, I noticed that I was getting great performance. What’s the diff, yo?
Turns out that there was a check on every single post determining if someone has got enough votes to be able to vote themselves. We don’t really use the feature, so it’s completely redundant. I have turned the check off, and I’m getting great performance on loading again.
Good news for any HPB (high point bastards) in similar straits.