Which Django caching system is faster: file system or DB?

Question

I know that between them there is not necessarily a clear reduction, as between Memcached DB / Filesystem, but I wonder what conditions will lead to the fact that the file system will be faster than caching the database. And vice versa, under what conditions will database caching be faster than a file system?

Answer 1

File systems are always faster than databases. Databases have overheads such as locking, fragment buffers, SQL parsing, query scheduling, etc. Etc.

Ultimately, the database lives on the file system. A database is a file system plus overhead.