Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

asp.net: question what is the best way to save pictures in a storage file or Database?

Posted on 2010-08-22
6
Medium Priority
?
382 Views
Last Modified: 2013-11-08
what would be the best way to handle images saving to a file on the server or to the database...the website is one that allows a user to add pictures to an ad that the user plans to sell something and the user can add upto 6 pictures per listing. we have no control weather the user can modify the picture size. the user can post the ad and delete the ad.
0
Comment
Question by:westdh
[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
6 Comments
 
LVL 7

Accepted Solution

by:
Norush earned 500 total points
ID: 33496164
This has been discussed on the offical Microsoft asp.net forums:

Here is the link to the discussion: http://forums.asp.net/t/874333.aspx

This one also answers this question quite well: http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html


0
 
LVL 10

Assisted Solution

by:Espavo
Espavo earned 1000 total points
ID: 33496683
Personally... I'd save these images to the database... (I've used both methods and have found the database version much better than saving to the filesystem...)
Espavo
0
 

Author Comment

by:westdh
ID: 33497386
I believe the database is better also... but why I am not sure.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 10

Assisted Solution

by:Espavo
Espavo earned 1000 total points
ID: 33498318
Some of the reasons why I use the database method are:
  • Easy to manage images, and their location...
  • No need to keep track of 1,000s of physical files in folders...
  • HDD doesn't become fragmented because of LOTS of files (better HDD performance)...
  • If a user "closes his account", you simply delete the related images from the DB... (no need to identify and delete files)
  • No worrying about image naming convention...
0
 
LVL 16

Assisted Solution

by:Vikram Singh Saini
Vikram Singh Saini earned 500 total points
ID: 33498425
Hi,

It depends on what is your priority of saving images such as do you want to get more management done for you itself (database best) or if you want fast response of saving images (file system best). But when you are trying to update or upgrade your website which one will be good for you?

What are the thoughts of other people who are already working in the field. So for that check links:

(1) http://www.onlineaspect.com/2007/07/10/image-storage-database-or-file-system/
(2) http://stackoverflow.com/questions/561447/store-pictures-as-files-or-in-the-database-for-a-web-app

Regards,
VSS
0
 

Author Closing Comment

by:westdh
ID: 33500401
Thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

618 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