Should I use db to store file?

Question

DB tables are much better when: You want to store many rows with the exact same structure (no block waste) You need lightning-fast lookup / sorting by more than one value (indexed tables) You need atomic transactions (data safety) Your users will read/write the same data all the time (better locking) 30 июн. 2016 г.

Is it a good idea to store files in DB?

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.

Can we store file in DB?

The purpose was to store and manage unstructured files more effectively. Before FILESTREAM was introduced, the following approaches were used to store the data in SQL server: Unstructured files can be stored in the VARBINARY or IMAGE column of a SQL Server table.

Expert · Answer

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.

Expert · Answer

The purpose was to store and manage unstructured files more effectively. Before FILESTREAM was introduced, the following approaches were used to store the data in SQL server: Unstructured files can be stored in the VARBINARY or IMAGE column of a SQL Server table.

Should I use db to store file?

Is it a good idea to store files in DB?

Can we store file in DB?

Related Questions