Which is better saving files in database or in file system?

Question

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. 30 июн. 2016 г.

Why is it better to store data in a database rather than in the 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.

Which one is better file system or DBMS?

DBMS provides a good protection mechanism. It isn't easy to protect a file under the file system. DBMS provides a crash recovery mechanism, i.e., DBMS protects the user from system failure.

Which is faster file system or database?

So for very simple operations, the filesystem is definitely faster. Filesystems will probably beat an RDBMS for raw read throughput too since there is less overhead. In fact, if you think about it, the database can never be faster than the filesystem it sits on in terms of raw throughput.

Is it okay to store files on database?

DB provides data integrity between the file and its metadata. Database Security is available by default. Backups automatically include files, no extra management of file system necessary. Database indexes perform better than file system trees when more number of items are to be stored.

Expert · Answer