Closed samanthadrago closed 11 months ago
Query plans for OLTP queries are cached; it would be nice to also cache OLAP stream query plans, both for feature parity and performance reasons.
At Etsy we use OLAP mode for queries. We implemented a patch to Vitess to cache the query plans for stream queries to help improve query performance.
cc @vitessio/query-serving
mattlord
commented
1 year ago mattlord
commented
1 year ago
Feature Description
Query plans for OLTP queries are cached; it would be nice to also cache OLAP stream query plans, both for feature parity and performance reasons.
Use Case(s)
At Etsy we use OLAP mode for queries. We implemented a patch to Vitess to cache the query plans for stream queries to help improve query performance.