Haha, sure, but the very first thing you should ask when faced with a slow query is to see the “explain analyse” output.
Caching, in any form, is the last thing you want to reach for because it’s always more nuanced than you anticipate.
To clarify, when asking the question it’s after drilling through the layers from the frontend -> backend -> query and the actual query is on the screen along with some table metrics as a guide.
Caching, in any form, is the last thing you want to reach for because it’s always more nuanced than you anticipate.
To clarify, when asking the question it’s after drilling through the layers from the frontend -> backend -> query and the actual query is on the screen along with some table metrics as a guide.