Solved

Preferred Method of Storing Images on a Website

Posted on 2013-06-21
3
250 Views
Last Modified: 2013-07-03
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!
0
Comment
Question by:VBBRett
3 Comments
 
LVL 58

Accepted Solution

by:
Gary earned 167 total points
Comment Utility
General rule of thumb is on the file system
http://research.microsoft.com/apps/pubs/default.aspx?id=64525
0
 
LVL 15

Assisted Solution

by:gplana
gplana earned 166 total points
Comment Utility
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.
0
 
LVL 12

Assisted Solution

by:Jitendra Patil
Jitendra Patil earned 167 total points
Comment Utility
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.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now