Is it adviseable to have very large threads on your forum?

[N9ne]

I have one thread on my forum which has 12100 replies but grows rapidly, and will probably be at 15000 in a few weeks, now is it advisable to keep this thread? My bandwidth usage is doing fine, but does it affect load or anything?

[mfinc]

Originally posted by N9ne
I have one thread on my forum which has 12100 replies but grows rapidly, and will probably be at 15000 in a few weeks, now is it advisable to keep this thread? My bandwidth usage is doing fine, but does it affect load or anything? Why not :)

[tubedogg]

Originally posted by N9ne
I have one thread on my forum which has 12100 replies but grows rapidly, and will probably be at 15000 in a few weeks, now is it advisable to keep this thread? My bandwidth usage is doing fine, but does it affect load or anything? Only X posts are loaded at the same time (X being the number of posts you view per page)...all of the posts in a thread will never be loaded at the same time. There are no load issues associated with it. You can have 15,000 1 post threads or 1 15,000 posts thread, no difference.

[CeleronXT]

Unless of course someone pulls one of these on you: http://www.sdsym.net/forum/showthread.php?amp;threadid=2171&perpage=20000&pag enumber=1 (perpage var set to 20000) and tries to load 20,000 posts per page.

[tubedogg]

Originally posted by CeleronXT
Unless of course someone pulls one of these on you: http://www.sdsym.net/forum/showthread.php?amp;threadid=2171&perpage=20000&pag enumber=1 (perpage var set to 20000) and tries to load 20,000 posts per page. Pretty sure there's a hardcoded limit if it's over X posts...can't remember what X is though.

[eva2000]

Originally posted by CeleronXT
Unless of course someone pulls one of these on you: http://www.sdsym.net/forum/showthread.php?amp;threadid=2171&perpage=20000&pag enumber=1 (perpage var set to 20000) and tries to load 20,000 posts per page. latest 2.2.x has that fixed so you can't do that.. i use to do that on some vBs i'm a member at because they have limited 10 - 30 posts/page options... i tend to like 40 - 60 posts/page for my viewing

[rylin]

Originally posted by tubedogg
You can have 15,000 1 post threads or 1 15,000 posts thread, no difference.

Want to take a bet? ;)
Let's see (note, this applies to vb2, no idea on the vb3 approach).

One thread, 15000 replies.
Let's assume we have 5000 unique users posting in this thread.

Let's assume 2500 of them have notify-on-reply set to auto in their profile.

Someone posts a reply, and BOOM!
Launching 2500 sendmail processes = *UGH*

Obviously, this does depend on a few things, but saying that large threads don't make a difference when it comes to system load isn't quite true.

Yes, there'll probably be a much lower number of users who have email notification on, but i'm just pointing it out ;)

[CeleronXT]

Well, you can still pull something like this to list 10,000 members on a forum.

http://www.vbulletin.com/forum/memberlist.php?do=getall&ltr=&perpage=10000&sortor der=asc&postslower=&postsupper=&sortfield=username &ausername=&homepage=&icq=&aim=&yahoo=&msn=&joinda teafter=&joindatebefore=&lastpostafter=&lastpostbe fore=&pagenumber=3

That has to be one hefty query.

[MattR]

Originally posted by CeleronXT
Well, you can still pull something like this to list 10,000 members on a forum.

http://www.vbulletin.com/forum/memberlist.php?do=getall&ltr=&perpage=10000&sortor der=asc&postslower=&postsupper=&sortfield=username &ausername=&homepage=&icq=&aim=&yahoo=&msn=&joinda teafter=&joindatebefore=&lastpostafter=&lastpostbe fore=&pagenumber=3

That has to be one hefty query. Not to mention hell on the browser! I think print thread 'breaks' on large threads for the same reason.

[tubedogg]

Originally posted by MattR
Not to mention hell on the browser! I think print thread 'breaks' on large threads for the same reason. printthread was changed several versions back to not allow viewing over X posts at once no matter what the perpage var is (can't remember what X is offhand).

[Chris Stewart]

Originally posted by CeleronXT
Well, you can still pull something like this to list 10,000 members on a forum.

http://www.vbulletin.com/forum/memberlist.php?do=getall&ltr=&perpage=10000&sortor der=asc&postslower=&postsupper=&sortfield=username &ausername=&homepage=&icq=&aim=&yahoo=&msn=&joinda teafter=&joindatebefore=&lastpostafter=&lastpostbe fore=&pagenumber=3

That has to be one hefty query.

Ouch, get ~100 people to load that page at once. Bubye vB server. :o

[Wayne Luke]

Originally posted by CeleronXT
Well, you can still pull something like this to list 10,000 members on a forum.

http://www.vbulletin.com/forum/memberlist.php?do=getall&ltr=&perpage=10000&sortor der=asc&postslower=&postsupper=&sortfield=username &ausername=&homepage=&icq=&aim=&yahoo=&msn=&joinda teafter=&joindatebefore=&lastpostafter=&lastpostbe fore=&pagenumber=3

That has to be one hefty query. I don't know... The entire page loaded in about 10 seconds for me under DSL with Windows XP and IE 6.0. Didn't really seem to phase anything.

[CeleronXT]

Originally posted by Wayne Luke
I don't know... The entire page loaded in about 10 seconds for me under DSL with Windows XP and IE 6.0. Didn't really seem to phase anything. It loaded in about 5 seconds for me, and I know why. That's page 3 (and with 10k posts per page, 3 is the last page), meaning that there wasn't the full 10k on the page. Set the pagenumber= to 1 and try it. I did, and it froze my browser.