Solved

Preferred Method of Storing Images on a Website

Posted on 2013-06-21
3
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 58

Accepted Solution

by:
Gary earned 167 total points
ID: 39266771
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
ID: 39266774
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 13

Assisted Solution

by:Jitendra Patil
Jitendra Patil earned 167 total points
ID: 39267618
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

617 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