> not realizing how much time has gone into developing well tuned caches within the database system itself

File systems too. A cron job writing a csv makes a surprisingly simple cache the OS can keep in memory.