View Single Post
  #7  
Old 12-29-2013, 11:43 PM
pattycake pattycake is offline
 
Join Date: Jan 2009
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Zachery View Post
impex could have handled the size of your database

Anyway, you'd still likely need to follow the after the import rules.

Rebuild the thread, and forum counters.
I tried impex several times... 5 million posts, and gave up after waiting as long as 5 days just for the posts and, it wasn't even halfway thru the posts.

140,000 users took 48 hours. It flat out died so many times I just said the heck with it and wrote my own in C.

140,000 users added in 11 minutes, 5 million posts in 2 1/2 hours.

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

Quote:
Originally Posted by RichieBoy67 View Post
If you want your posts to be recounted you use the Post count update tool in the maintenance section. Be sure to clear your cache in the maintenance section as well.

Are you saying you want a fake count number?
no, I don't want to use a fake number - I have over 5 million posts. Do you know where that value is stored (in what table)?

If I can just edit that number, I won't have to wait for hours for the 140,000 threads and 200 forums to process (assuming I have to do the thread and forum counters as mentioned below)

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

Quote:
Originally Posted by RichieBoy67 View Post
If you want your posts to be recounted you use the Post count update tool in the maintenance section. Be sure to clear your cache in the maintenance section as well.

Are you saying you want a fake count number?
tried that... it updated the post counts for all members (4 hours runtime), but not that total at the bottom of the index page
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01358 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
  • (3)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