vb.org Archive - Attachments in database or filesytem?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Attachments in database or filesytem? (https://vborg.vbsupport.ru/showthread.php?t=102690)

Rick Sample

12-10-2005 11:30 PM

Attachments in database or filesytem?

I'd like to hear from the pros. What's the best way to store your attachements? I just noticed that vbulletin allows you to select this option. Our database is very large. Most of it is attachements, only 300MB's is data.

BamaStangGuy

12-10-2005 11:59 PM

File System

Revan

12-11-2005 09:52 AM

Depends on the amount of available disk space you have.
Some hosts offer only 100 MB of diskspace (for instance) but doesn't monitor SQL storage space. That's why vBulletin has the option to store avatars and attachments in the database.
If you have 5GB+ then you (YA) RLY should store both those things in the FS, to allow for quicker backups and restoration of said.

Wayne Luke

12-11-2005 02:52 PM

Quote:

Originally Posted by Rick Sample

For performance reason, file system for attachments all the time.

grains

11-03-2006 06:14 AM

how can we change this setting?

Princeton

11-06-2006 01:12 PM

<a href="http://www.vbulletin.com/docs/html/attachment_storage" target="_blank">http://www.vbulletin.com/docs/html/attachment_storage</a>

All times are GMT. The time now is 07:00 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01160 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: