Databases
StackOverflow2013
Postsdbo
POStore pictures as files or in the database for a web app?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStore pictures as files or in the database for a web app?
    text
    copied!<p>My question is fairly generic and I know there might not be an 100% answer to it. I'm building an ASP .NET web solution that will include a lot of pictures and hopefully a fair amount of traffic. I do really want to achieve performance.</p> <p>Should I save the pictures in the Database or on the File system? And regardless the answer I'm more interested in why choosing a specific way.</p> <p>Many thanks, Stefan </p> <p><strong>DUPLICATE</strong>: <a href="https://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay" title="Storing Images in DB - Yea or Nay?">Storing Images in DB - Yea or Nay?</a>, <a href="https://stackoverflow.com/questions/191845/how-to-store-images-in-your-filesystem" title="How to store images in your filesystem">How to store images in your filesystem</a>, <a href="https://stackoverflow.com/questions/325126/storing-a-small-number-of-images-blob-or-fs" title="Storing a small number of images: blob or fs?">Storing a small number of images: blob or fs?</a> and probably some others.</p> <hr> <p>COMMENT: Thanks for many good answers. I will go for a file based solution even if I like the idea of having a 100% database driven solution. It seems that there are today good solutions to do what I want with databases etc but I have a few reasons for not doing it.</p> <ul> <li><p>I will be on a hosted solution, I have huge amount of storage(10gb) but only 300mb for the database. It will cost a lot for extra storage in the DB.</p></li> <li><p>I'm not an DB expert and as well not in control of settings of the DB. A DB based solution might need custom configuration as it looks like.</p></li> </ul> <p>If we will move to run the site on our own server I might consider a DB based solution. thanks, Stefan </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload