Warming cache

When cache is slower than one query

I found myself refactoring a lot of our ETL code due to poorly designed cache and I want to share an abstract of my learnings.

tl;dr; Pre-load all the data that the program is likely going to require instead of querying and caching data when it is needed.

Tuning our ETL process like it was a race car.

Input data