Storing a file in a database as opposed to the file system?

by

Have a look at this answer:

Storing Images in DB – Yea or Nay?

Essentially, the space and performance hit can be quite big, depending on the number of users. Also, keep in mind that Web servers are cheap and you can easily add more to balance the load, whereas the database is the most expensive and hardest to scale part of a web architecture usually.

There are some opposite examples (e.g., Microsoft Sharepoint), but usually, storing files in the database is not a good idea.

Unless possibly you write desktop apps and/or know roughly how many users you will ever have, but on something as random and unexpectable like a public web site, you may pay a high price for storing files in the database.

More Related Contents:

  1. Updating image in VB and SQL Server not working [closed]
  2. What are the main performance differences between varchar and nvarchar SQL Server data types?
  3. Multiple Indexes vs Multi-Column Indexes
  4. Preferred Method of Storing Passwords In Database
  5. Using a sort order column in a database table
  6. Create a view with ORDER BY clause
  7. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  8. How to do version control for SQL Server database?
  9. What columns generally make good indexes?
  10. How to check if a database exists in SQL Server?
  11. Getting execute permission to xp_cmdshell
  12. TSQL: Create a view that accesses multiple databases
  13. Storing Images : DB or File System –
  14. How to migrate a PostgreSQL database into a SQLServer one?
  15. What is the point of “Initial Catalog” in a SQL Server connection string?
  16. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  17. How to create a yes/no boolean field in SQL server?
  18. User images – database vs. filesystem storage [duplicate]
  19. Best way to store time (hh:mm) in a database
  20. Executing set of SQL queries using batch file?
  21. Database design: Calculating the Account Balance
  22. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  23. Date range overlapping check constraint
  24. What are the advantages of VistaDB
  25. Difference between database and schema
  26. Generate table relationship diagram from existing schema (SQL Server) [closed]
  27. Calculate Time Difference Between Two Rows
  28. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  29. How do you deal with blank spaces in column names in SQL Server?
  30. Tool for Scripting Table Data

Leave a Comment