Which Django Caching System is Faster: Filesystem or DB?

Question

I know there isn't necessarily a clear cut between these two like there is between Memcached an DB/Filesystem, but I'm wondering what conditions would lead to filesystem being faster than DB caching. And, conversely, under what conditions would DB caching be faster than filesystem?

S.Lott · Accepted Answer · 2011-09-09 20:48:03Z

11

Filesystems are always faster than databases. Databases have overheads like locking, shard buffers, SQL parsing, query planning, etc., etc.

Ultimately, the database lives on the filesystem. A database is filesystem plus overheads.

answered Sep 9, 2011 at 20:48

S.Lott

393k83 gold badges521 silver badges791 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lie Ryan Over a year ago

good point, although I would add that for most purposes, there will likely be no measurable difference in the speed of as DB can likely serve from memory and good OS have file cache in memory. So, before you decide on one or the other, you need to determine whether the caching system is really the bottleneck in your app.

S.Lott Over a year ago

@Lie Ryan: Measure before optimizing. Good advice.

Collectives™ on Stack Overflow

Which Django Caching System is Faster: Filesystem or DB?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related