The Arcive of Official vBulletin Modifications Site.

hotnuts21 · #1 09-26-2005, 08:12 PM

I am helping a friend to Administer quite a large Vbulletin based site. In the last week or so we have had a lot of dowtime on the site, due to to many connections and the current downtime we are unsure of the reasons. However it is just this site and just this database out of a lot we have hosted with this host, and some on the same server, we have a little gallery script installed on the same domain and using a database which is running fine. I cannot even connect to the vb database with phpmyadmin.

The host we use is very reliable and has a very good reputation we also have lots of space on the server. The site he runs is for web design, just about every thread is full of medium to high quality images of web pages, logos etc. On average a thread lasts for 3-5 pages with probably 50% of the posts containing an attachment.

The site is configured (I think. We cannot access anything to confirm it) to store all images in the database. Our SQl usage is currently at 7327.38 over 98% of that is the Vbull database. Im wondering if such a huge database is what is causing all the problems, does this sound feasible?

Is it possible to set it up so images are stored on the server in a folder instead of the database so we can keep the database a little more optimized. Also is it possible to convert all images currently held in the database into the folder, I have a feeling the server will cope better with a large folder and smaller database. Is this possible to do? Thanks for the help. rgds Paul

Marco van Herwaarden · #2 09-26-2005, 08:21 PM

AdminCP->Attachments->Attachemnt Storage Type

hotnuts21 · #3 09-26-2005, 08:45 PM

Will this convert the current 1000+ images from the database to a folder?
thnx
Paul

Marco van Herwaarden · #4 09-27-2005, 03:55 AM

Yes. But make sure you create a backup before you start this.

dieselpowered · #5 09-27-2005, 04:29 AM

Quote:

Originally Posted by MarcoH64

Yes. But make sure you create a backup before you start this.

So is it better to store attachments in the file system or store them in the database???

Marco van Herwaarden · #6 09-27-2005, 06:08 AM

Depends on a lot of factors what is better. But if you have a lot of attachment it would be better to move to filesystem in most cases.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04278 seconds Memory Usage 2,204KB Queries Executed 11 (?)
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)bbcode_quote (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_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
Messages:

The Arcive of Official vBulletin Modifications Site.

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