BLOB vs LINK

Question

User442013226 posted

Hello everyone,

I have a website that sotres many images from movies. Some of these are very large up to 20MBsome are very small. I was just wondering what the best way to store these images is. At the moment I have them stored on the disk of my server, and I have for example a column in my database called CoverImage which stores a link like "Images/DateNightCvr.jpg", this seems to work well but I was just wondering what the performance differences are between these two ways of storing data.

Thanks

 

James 

Answer 1

User-863835478 posted

Your current way is the best. See below:

http://forums.asp.net/t/1096999.aspx

Answer 2

User581921910 posted

Hi,

I think you should atlease save the Thumbnail of the images in DB and show them as Big. Will that be efficient enough right ?

Thanks,

Thanigainathan.S 

Answer 3

User-952121411 posted

The only time I reccomend storing files as a BLOB in SQL is when the images or files contain sensitive data (i.e. Medical Images, etc.) where you need the security that SQL Server provides.  Otherwise storing and reading the file from a File Sytem is much faster; you can keep a reference to the file's location in SQL Server for the best method.  Read this as well:

"performance wise, including an <IMG SRC> tag generated by the database and pointing to a file that already exists is going to be faster than pulling the file out of the database, generating a temp file on the web server, and streaming that to the user. Also, table scans take more resources when there is an image datatype as opposed to a varchar that simply holds a 'pointer' to the file's location." 

Should I store images in the database or the filesystem?

http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

Answer 4

User442013226 posted

Thankyou everyone,

I think you've convinced me to stick with my orgininal plan :)

 

James