I have program that saves unique images that are related to unique database fields to database as binary fields or save in folders as image files?
+2
A:
It depends on what you need to do with the images, how often you access them and how often they change.
There is no right answer for this one - it really depends on what you are trying to achieve.
Oded
2010-01-12 10:23:31
Images are big in size, for example 500k-1mb
newbie
2010-01-12 10:25:44
Doesn't matter. How many images are you talking about? What are the usage scenarios?
Oded
2010-01-12 10:28:43
One image is approximately loaded 5-10 times per session
newbie
2010-01-12 10:41:16
You can always save the image data to the filesystem first time it is called and pick it up from there (and if `! File.Exists(path)` refetch from DB.
Oded
2010-01-12 11:01:34
+1
A:
I would rather use a distinct key/value storage if available. This can be hosted by your own or something like Amazon S3. If not, better save the images as files and organize meta data and path information in your database.
PartlyCloudy
2010-01-12 10:28:51