> Traditional databases would compute the results of this query from scratch every time it was issued. Is this really the case that queries can't be cached on traditional databases?
ReadySet PM here - depends on if there are writes to the table or not! For example, MySQL deprecated their query cache, but previously it would only cache until there were any writes to the tables that the queries were referencing https://dev.mysql.com/doc/refman/5.7/en/query-cache-configur...
Even CochroachDB doesn't do query cache, only query planning is cached. [0] [1]
[0] https://www.cockroachlabs.com/blog/memory-usage-cockroachdb/
[1] https://www.cockroachlabs.com/blog/query-plan-caching-in-coc...