Yup, 100k replies in one thread. We have quite a few threads with replies in the thousands, and have never had a problem until recently. Most everything I've read says thread size should not have a significant effect on server performance or load times.
It's a decent sized forum,
Threads: 25,905, Posts: 1,279,387, Members: 55,056
but I visit other larger forums with longer threads that never seem to have similar problems.
snakes1100, thanks for the reply. Our mysql configuration is pretty well optimized, or so I think at least. I'm going to post in the server optimization forum over at vbulletin.com and see if I missed something though.
--------------- Added [DATE]1224091682[/DATE] at [TIME]1224091682[/TIME] ---------------
Quote:
Originally Posted by Lynne
We have a thread with a bit over half that many replies and so far I have decided not to split it. It takes about 1.2 seconds to load compared to .1 seconds on other pages, so there is definitely a difference for load times of big threads. I've heard some people just like to split them (and close them) at some point. I think there is a mod to automatically do this, but if I recall there are problems with it. If it's just a single thread, it should be no problem for you to just deal with it on your own.
|
I did end up closing it and started a new monthly version of the thread. It's an "off-topic" thread that's been running for probably over 5 years now, so It's a tradition that I wanted to keep alive and a monthly off-topic thread should keep my users happy.
Like I said though, most everything I'v read said thread length shouldn't effect load times (even though I too noticed a clear difference), and I visit other forums that are more active and have longer threads. I was hoping to find a workaround or tips on optimizing my server/database to handle these types of situations.