This post is about trying to limit SQL queries, by the use of a method called “caching”. I’m going to talk about different methods ways of thinking about caching.

In my 20+ year career as a coder I have seen, many times, cases where someone thought they had found a way to make things easier and simpler, and, this is the crucial bit, more powerful. I did a maths degree at Uni, and I intrinsically understood the problems here. It’s the law of diminishing returns. Let’s get concrete with some examples. The no code lego-esque dream that never dies The first time I thought about it was in my first job out of uni in 2002.