Images in database vs file system

by

There was a nice research paper published by Microsoft Research called To Blob or not to Blob where they looked at all sorts of variables and impacts.

Their finding in the end:

  • up to 256 KB in size, blobs are stored in the database more efficiently than in the file system
  • for 1 MB and larger, the file system is more efficient
  • in between it’s a toss-up

Since that paper was published, SQL Server 2008 has also added the FILESTREAM attribute which makes storing stuff in the file system, but under transactional control, a reality. Highly recommended you check that out!

More Related Contents:

  1. Are Parameters really enough to prevent Sql injections?
  2. What is the best way to read/parse the XML files [closed]
  3. Store pictures as files or in the database like MSSQL for a web app?
  4. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  5. Querying data by joining two tables in two database on different servers
  6. Generate a resultset of incrementing dates in TSQL
  7. How can I force entity framework to insert identity columns?
  8. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  9. Howto? Parameters and LIKE statement SQL
  10. thread messaging system database schema design
  11. Display image from database in ASP.net with C#
  12. Preventing SQL Injection in ASP.Net
  13. EF 4.1 exception “The provider did not return a ProviderManifestToken string”
  14. Entity Framework 4 – Update database schema from model. Without wiping the table data
  15. How to check which locks are held on a table
  16. DataBinding: ‘System.Data.DataRowView’ does not contain a property with the name
  17. Accessing Session Using ASP.NET Web API
  18. Read SQL Table into C# DataTable
  19. What is the App_Data folder used for in Visual Studio?
  20. Adding ASP.NET MVC5 Identity Authentication to an existing project
  21. The Next-gen Databases [closed]
  22. Insert Picture into SQL Server 2005 Image Field using only SQL
  23. Execute Stored Procedure from a Function
  24. EditorTemplate for DropDownList
  25. How to compare two dates to find time difference in SQL Server 2005, date manipulation
  26. Change textbox’s css class when ASP.NET Validation fails
  27. Is it possible to share the web.config across multiple projects in a solution?(ASP.NET)
  28. How to decide which is right, WebForms or MVC when doing ASP.NET
  29. Postgres: convert single row to multiple rows (unpivot)
  30. Does any change in any file inside bin folder cause application recycle in ASP.NET web application?

Leave a Comment