Anonymous Asked in Cars &Transportation · 2 weeks ago

Is storing files in a database a bad idea?

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. 12 авг. 2008 г.


Is it good to store files in database?

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.

Should I store files in the database or file system?

Saving the files and downloading them in the file system is much simpler than database since a simple Save as function will help you out. Downloading can be done by addressing an URL with the location of the saved file.

Why is it better to store data in a database rather than in the file system?

Easy recovery: Since database systems keeps the backup of data, it is easier to do a full recovery of data in case of a failure. Flexible: Database systems are more flexible than file processing systems.

Why would you choose to store data in a database instead of many individual files?

Databases support good data access because: Large volumes of data can be stored in one place. Multiple users can read and modify the data at the same time. Databases are searchable and sortable, so the data you need can be found quick and easily.

Related Questions

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