This article is different from my usual posts. It explains things that may be obvious to many database professionals – not all of them though.
The idea came indirectly from my friend Francesco Allertsen. He has a weekly mailing list he uses to share links to interesting articles he reads on the web. One of them was The hidden components of Web caching. Its purpose is to list all caches that play some role when we interact with a web site. An interesting idea, even if I find it incomplete. So I thought it was a good idea to talk about caches that we hit whenever we interact with a database.
Why should we care?
But first, a note on why we should care: …[Read more]