Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Where should I store files in database?

Contents
  1. Where should database files be stored?
  2. Is it a good idea to store files in DB?
In many cases, this is a bad idea. It will bloat the database files and cause several performance issues.Is storing files of up to 50MB in size in a database for use by multiple .Store images in the database, or in files with a database link?Why use a database instead of just saving your data to disk?Where to store many files? - Software Engineering Stack ExchangeДругие результаты с сайта softwareengineering.stackexchange.com


Where should database files be stored?

Storing Files in SQL Database Using FILESTREAM – Part 11Unstructured files can be stored in the VARBINARY or IMAGE column of a SQL Server table. ... 2Instead of storing the entire file in the SQL table, store the physical location of the unstructured file in SQL Table.Storing Files in SQL Database Using FILESTREAM - Part 1

Is it a good idea to store files in DB?

Reasons in favor of storing files in the database: Having the files and database in sync and able to participate in transactions can be very useful. Files go with the database and cannot be orphaned from it. Backups automatically include the file binaries.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours