vb.org Archive - storing attachments in the db-pros and cons

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

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

- - storing attachments in the db-pros and cons (https://vborg.vbsupport.ru/showthread.php?t=217365)

PhilipAlv

06-28-2009 09:34 PM

storing attachments in the db-pros and cons

hello guys...what is the good and bad about storing attachments in the db ?

PhilipAlv

07-20-2009 06:21 PM

anyone....?

James Birkett

07-20-2009 06:37 PM

I can't remember entirely but storing it in the database reduces server load doesn't it?

Lynne

07-20-2009 06:41 PM

There is a post over on vb.com about the pros and cons. In fact, it may even be in the manual (linked in my sig).

James Birkett

07-20-2009 06:44 PM

Quote:

Storing in Database:
Pro
Backing up your database, also backs up your attachments
Does not consume any of your file system storage limits (unless mysql storage counts)
Con
Can increase server load on large forums
Storing in File system:
Pro
Better performance for large forums
Easier to backup your database
Con
Does not work if SAFE MODE is enabled on your server.
Need to backup attachments separately from database
Consumes space on your file system

Looks like I got them mixed up.
Basically:
If you want speed, back up on file system.
If you want space, back up on database.

All times are GMT. The time now is 05:35 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00988 seconds Memory Usage 1,720KB 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 (5)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: