vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Blobbing images or file structure (https://vborg.vbsupport.ru/showthread.php?t=58225)

cinq 10-27-2003 05:12 AM

Blobbing images or file structure
 
Which would be a better means to storing images ?
And why ?

Inputs required :)

Zachery 10-27-2003 09:37 AM

Quote:

Originally Posted by cinq
Which would be a better means to storing images ?
And why ?

Inputs required :)

im totaly confused by this :\

Dean C 10-27-2003 10:17 AM

He means is it better to store images in the database as a blob or as a file in a directory. Personally I prefer using directories as working with files in PHP is pretty easy :)

Dominus 10-27-2003 10:49 AM

database + mysql4 = your best friend

Storing files in DIR, I found it hard to find anything when you have alot of files(as categorizing/linking+mysql backend), also for backup, you can just dump mysql and your done, you dont have to download your whole data structure to make a backup. :(

cinq 10-27-2003 11:13 PM

Quote:

Originally Posted by Mist
He means is it better to store images in the database as a blob or as a file in a directory. Personally I prefer using directories as working with files in PHP is pretty easy :)

Thanks for the clarification Mist, and the input.
Thanks too to Dominus for his/her input.

One issue:
Will the SQL end be 'slower' if i blob the data ?

Brad 10-28-2003 12:36 AM

Quote:

Originally Posted by cinq
Thanks for the clarification Mist, and the input.
Thanks too to Dominus for his/her input.

One issue:
Will the SQL end be 'slower' if i blob the data ?

SQL will most likely be the same on speed depending on how you are pulling the results. Keep in mind that the table the images are stored in can grow large and might hurt you later on if you do not have telnet or other means of backing up the database without a php or some other kind of script that can timeout.


All times are GMT. The time now is 01:10 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03272 seconds
  • Memory Usage 1,718KB
  • 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
  • (3)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