Preferred Method of Storing Images on a Website

What is the preferred method of storing uploaded images onto a website as far as technology goes today?  Is it storing an image as an image type in SQL Server, storing the image as a varbinary type in a SQL Server table, storing the image as a file blob in a local directory on the server and having it retrieved when needed?  What do you guys think is the best and most effecient way to do this?  Thanks!
Who is Participating?
GaryConnect With a Mentor Commented:
General rule of thumb is on the file system
gplanaConnect With a Mentor Commented:
It depends of what do you want to do with the image, but most of the times you will prefer to store the image as a file so operating system can access to it. Also if you store the image as a file you can just store the file name on a varchar field and avoid using the blob specific operations to handle with the image.

If you need the image to be included on some transactions inside the database, then it should be better to store it inside the database.

Hope it helps.
Jitendra PatilConnect With a Mentor Sr.Software EngineerCommented:
store images on a disk rather than database, instead just store the path to image in database, that will take less space than actual image in your database.

hope this helps.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.