30k+ reply threads, use more processing power?
 

Do they? I notice when I go to one of my 30k post threads, going all the way to the last page takes like 3 times as long for the page to load.

Is there anywhere to speed up the loading time?

bump...also my users are reporting that, when they go the last page of these threads...for example page 2200, the pagination states that there are more pages. Why is that? When go to those "phantom" pages, it just redirects them to the page they are on.

I'm using the lastest version of vb btw.

--------------- Added [DATE]1192805821[/DATE] at [TIME]1192805821[/TIME] ---------------

bump no one eh?

No one knows the answer?

Im having that issue as well on my board. For me its because ive put some users on the global ignore list. (Meaning that their posts doesnt show up). However, vB doesnt (yet? ) take the hidden posts into account when calculating the pagination.
The fix for me was quite easy: Delete all posts from users on global ignore. As the posts doesnt show up anyway no one will miss them.

Edit: And a guess on your initial question: Yes, I THINK Mysql has to search through all posts up to the current ones to be able to display them.
I try to lock threads before they grow to that size and then create a new thread called "part 2" where the discussion can continue..

It's a known "limitation" for most big boards. Many end up hacking showthread.php a bit to avoid it, because basically what happens is it has to count the number of posts in that thread every time when handling the pagination.

Some sites split their threads after 1000 or so replies, just for efficiency sake. If this is too much of a hassle, then you'll have to dig around for some of the optimization threads here. I remember a few detailed ones, but you're on your own finding them. Maybe someone else bookmarked them. Should be on vb.com, as well.

Awesome thank you for the advice. I will look into this.

Peter, I did your trick, and it worked flawlessly.