Anonymous Asked in Cars &Transportation · 2 weeks ago

Should I store files in database or filesystem?

In my own experience, it is always better to store files as files. The reason is that the filesystem is optimised for file storeage, whereas a database is not. 7 нояб. 2011 г.


Is it better to store files in database or filesystem?

Database provides a proper data recovery process while file system did not. In terms of security the database is more secure then the file system (usually). The migration process is very easy in File system just copy and paste into the target while for database this task is not as simple.

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.

Is it better to store images in database or filesystem?

Generally databases are best for data and the file system is best for files. It depends what you're planning to do with the image though. If you're storing images for a web page then it's best to store them as a file on the server. The web server will very quickly find an image file and send it to a visitor.

Why is database better than file system?

Easy access to data – Database systems manages data in such a way so that the data is easily accessible with fast response times. 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.

Related Questions

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