The Arcive of Official vBulletin Modifications Site.

(not prob, just question) about attachment table... · **Released**: 09-09-2002

Hi,

My board was running 2.2.6 and had a few hacks installed, it kept crashing the sql server and also has usage over 15.00 at times...

I installed the 'attachments to files' hack which removes attachments from the database and instead stores them as 'actual files' on your web server and at the same time upgraded to 2.2.7... I've also installed a bunch of other hacks...

2.2.7 is running superb... so does the attachment table have that much of an effect?? If so WHY is it in the database at all?

The attachment table before the conversion was just over 21,000 files and was 3GB in size.

Logician · #2 09-10-2002, 12:17 PM

Considering the file number you have in that table yes it can be the access requests to that table that slows down your board. It's always the best apporach to get rid of SQL connection whenever it's possible so it might be better to save the files directly in server instead of saving them in db but we must also accept that vb is a message board not a file management utility so having so much files in db might be considered "not likely".

Also keeping them inside db has its own advantages like more easily tracking their access, applying better access-security standarts to files, easily backup/manage the entire site (together with files) etc. So developers might choose to save them in db..

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09744 seconds Memory Usage 2,192KB Queries Executed 15 (?)
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)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (2)post_thanks_box (2)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit_info (1)postbit (2)postbit_onlinestatus (2)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!