Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page 10000+ cathegories and forums
FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 03-15-2009, 04:11 PM
Illthis Illthis is offline
 
Join Date: Feb 2009
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 10000+ cathegories and forums
Is is possible to turn off the datastore[forumcache]?Big thanks so far!!!
Reply With Quote
  #2  
Old 03-15-2009, 04:14 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
No, it isnt.
Reply With Quote
  #3  
Old 03-15-2009, 04:19 PM
Illthis Illthis is offline
 
Join Date: Feb 2009
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Damn.
How to manage datastore[forumcache] with 10000 and more forums and cathegories in one mysql-db?

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

I put about 10000 forums in the "forum"-mysql-table. always i run the misc.php?do=updateforum script i get a mysql database error, like this:

REPLACE INTO vb_datastore
(title, data, unserialize) VALUES ...
20:25

MySQL-Fehler : Got a packet bigger than 'max_allowed_packet' bytes
Fehler-Nr. : 1153
Fehler-Zeit : Sunday, 15.03.2009 @ 20:18:57
Datum : Sunday, 15.03.2009 @ 20:19:30
Skript : XXX/misc.php?do=updateforum&startat=11234&pp=100
Referrer : XXX/misc.php?do=updateforum&startat=11134&pp=100
IP-Adresse : XXX.XXX.XXX.XXX
Benutzername : XXX
Klassenname : vb_database
MySQL-Version : 4.1.22-max-log

Unfortunately my hoster dont allows me to change the max_allowed_packet size.
I dont get $config['Datastore']['class'] = 'vB_Datastore_Filecache'; in config.php working.
"includes/datastore/" and "includes/datastore/datastore_cache.php" has chmod777.
Is there anything to take care off?

Any idea for a solution?
Reply With Quote
  #4  
Old 03-16-2009, 09:11 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Using more then 1.500 forums/categories (and with a "normal" amount of usergroups) won't work on most servers.

The only possible solution would be to use vB2, which is probably not what you want.
Reply With Quote
  #5  
Old 03-17-2009, 06:30 PM
Illthis Illthis is offline
 
Join Date: Feb 2009
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
How many Threads VB can handle with?
Reply With Quote
  #6  
Old 03-18-2009, 06:21 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
A lot more (millions, maybe) - since thread information itself is not cached like forums are.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:02 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07049 seconds
  • Memory Usage 2,199KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete