Hacker News new | ask | show | jobs
by greg-m 1463 days ago
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...

1 comments

I was just looking this up and it's correct, they don't cache queries (if they do, it's a separate feature), they only manage query planning in ways that make them faster.

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...