Is it bad to store files in database?

Question

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?Where to store many files? - Software Engineering Stack ExchangeWhy use a database instead of just saving your data to disk?Другие результаты с сайта softwareengineering.stackexchange.com

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.

Is it bad to store images in database?

Storing images in a database table is not recommended. There are too many disadvantages to this approach. Storing the image data in the table requires the database server to process and traffic huge amounts of data that could be better spent on processing it is best suited to.

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

Storing images in a database table is not recommended. There are too many disadvantages to this approach. Storing the image data in the table requires the database server to process and traffic huge amounts of data that could be better spent on processing it is best suited to.

Is it bad to store files in database?

Is it a good idea to store files in DB?

Is it bad to store images in database?

Related Questions