The Arcive of Official vBulletin Modifications Site.

Do large threads slow town the average forum speed? · **Released**: 08-31-2006

At my forums there ar threads with more then 17000 posts.. Is it possible these threads are slowing the complete forums down?

I have about 170 users online now, only 3 of them are using the search function.
But my server loads vary from 1.20 - 3.20.. And the forums are extremely slow.

COBRAws · #2 08-31-2006, 07:46 PM

Well, I really dont know, but I've had discussions over this subject since I started using board software.

Ntfu2 · #3 08-31-2006, 07:48 PM

They shouldnt unless you're users are viewing that thread constantly or in large groups.

Either way it should still only retrieve the number of posts you have it set to display per page.

Eagle Creek · #4 08-31-2006, 08:27 PM

Currently Active Users Viewing This Thread: 46 (39 members and 7 guests)
==> that's for the 18.000 replies thread, 30 posts a page.

So imagine (it won't happen but say) al thse users where accessing a different page. That means 46*30 = 1380 posts requests out of the database.
That's a big number.. But propably most users are only browsing the last few pages of it.

Still.. My server loads are higher then I want them to have.

Quote:

Originally Posted by TenTenths@BigBoardsAdmin

Very likely, especially if they are popular threads and getting views, vBulletin has to count all the posts in the thread before it splits it into pages, so if you've a lot of users reading those threads then it'll be doing a LOT of processing just to display it.

Take a look at your slow queries log and you'll get a better idea of what's causing the forum to take it's time. Out of the box vB uses the myisam table type which will lock the post and thread table while the thread is being generated so this will slow down all the other thread display requests that are pending.

Aha! That sounds interesting.

Erwin · #5 08-31-2006, 09:40 PM

The answer is yes.

I limit all my threads to 1,000 posts (automatically split and linked). Reduced my load about 3 years ago when I started doing this by a lot.

Eagle Creek · #6 08-31-2006, 10:00 PM

Sounds great!

How do you limit threads to 1000 posts? Is that an option or a vB hack?

Option would be great! Aldough I have enough moderators, it would be nice if it would go automaticly.

Shazz · #7 08-31-2006, 10:05 PM

Any luck with the code that "makes your forums seem faster" . Anyone try it?

Eagle Creek · #8 08-31-2006, 11:16 PM

Exactly what it says it does, it SEEMS to make your forums faster.. When you're waiting about 5 seconds for a page to open that hack is useless.

jilly · #9 09-01-2006, 01:18 AM

Quote:

Originally Posted by Erwin

The answer is yes.

I limit all my threads to 1,000 posts (automatically split and linked). Reduced my load about 3 years ago when I started doing this by a lot.

i would be interested in how to set this up too! Can you share the secret with us,, erwin?

Shazz · #10 09-01-2006, 01:20 AM

Quote:

Originally Posted by Eagle Creek

Exactly what it says it does, it SEEMS to make your forums faster.. When you're waiting about 5 seconds for a page to open that hack is useless.

Ok lets say your forums were faster..
Whats the difference between "it seems faster" or "its faster"
Can you tell?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04679 seconds Memory Usage 2,287KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!