服务器负载数据库与文件操作

Question

I am trying to figure out which bears a heavier load on a system:

• A database operation
• OR a File operation (AKA reading an XML file)

Thanks in advance!

Answer 1

Usually file operations are slower than DB operations.

If you want to store a data collection in an XML file (ie. an XML database) I would unrecommend it, strongly. DBMSs implement lots of performance optimizations via indexes and caches: most of DB data is held in memory.

If you want to write large payloads to DB columns, it's not more efficient than having a column that points to a file and store the raw data inside the file.