Design Solution For Storing-Fetching Images

Posted by Chaitanya on Stack Overflow See other posts from Stack Overflow or by Chaitanya
Published on 2010-05-14T15:19:52Z Indexed on 2010/05/14 15:24 UTC
Read the original article Hit count: 245

This is a design doubt am facing, I have a collection of 1500 images which are to be displayed on an asp.net page, the images to be displayed differ from one page to another, the count of these images will increase in the time to come,

a.) is it a good idea to have the images on the database, but the round trip time to fetch the images from the database might be high.

b.) is it good to have all the images on a directory, and have a virtual file system over it, and the application will access the images from the directory

Do we have in particular any design strategy in a traditional database for fetching images with the least round trip time, does any solution other than usage of a traditional database exists?

ps: I use SQL Server to store these images.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about design