Store pictures as files or in the database like MSSQL for a web app?

by

Store the pictures on the file system and picture locations in the database.

Why? Because…

  1. You will be able to serve the pictures as static files.
  2. No database access or application code will be required to fetch the pictures.
  3. The images could be served from a different server to improve performance.
  4. It will reduce database bottleneck.
  5. The database ultimately stores its data on the file system.
  6. Images can be easily cached when stored on the file system.

More Related Contents:

  1. Are Parameters really enough to prevent Sql injections?
  2. How can I force entity framework to insert identity columns?
  3. thread messaging system database schema design
  4. Display image from database in ASP.net with C#
  5. Images in database vs file system
  6. Entity Framework 4 – Update database schema from model. Without wiping the table data
  7. Unrecognized attribute ‘targetFramework’. Note that attribute names are case-sensitive
  8. How to set correct file permissions for ASP.NET on IIS
  9. Recursive control search with LINQ
  10. Chrome localhost cookie not being set
  11. Can we use multiple forms in a web page?
  12. IE10 User-Agent causes ASP.Net to not send back Set-Cookie (IE10 not setting cookies)
  13. Difference between and ?
  14. MVC 5 Access Claims Identity User Data
  15. Generating a new ASP.NET session in the current HTTPContext
  16. Get URL of ASP.Net Page in code-behind [duplicate]
  17. Wcf-The maximum message size quota for incoming messages (65536) has been exceeded?
  18. Web Config Transform not working
  19. How to hide columns in an ASP.NET GridView with auto-generated columns?
  20. How can I get a MAC address from an HTTP request?
  21. What happens when I edit web.config?
  22. v11.0\WebApplications\Microsoft.WebApplication.targets was not found when file actually references v10
  23. How do I crop the contents of an Iframe to show a part of a page?
  24. How to disable submit behaviour of asp:ImageButton?
  25. what is the use of Eval() in asp.net
  26. IIS Session Timeout vs ASP.NET Session Timeout
  27. ASP.NET session state and multiple worker processes
  28. How to detect/track postback in javascript?
  29. Canceling the default submit button in ASP.NET
  30. IIS AAR – URL Rewrite for reverse proxy – how to send HTTP_HOST

Leave a Comment