View Single Post
  #5  
Old 10-15-2008, 04:23 PM
tomotron tomotron is offline
 
Join Date: Nov 2005
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 View Post
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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01173 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete