I would like some input on the best, most efficient way to store images for use on a website.
I would like some input on the best, most efficient way to store images for use on a website. The two main options that I see are storing images as a BLOB in SQL Server, or storing the URL of the file in SQL Server, and actually storing the image file on a file share. I have heard that storing in a SQL database as BLOB can be somewhat cumbersome when it comes to retrieval. What do you recommend?
You are correct in stating that storing BLOB objects in SQL Server is cumbersome. It is also slow.
The most commonly accepted way of managing images for a website is not to store the images in the database, but only to store the URL in the database, and to store the images on a file share that has been made a virtual folder of your web server.