Vincent de Gans created DRILL-8529:
--------------------------------------
Summary: Caching QueryPlan Results
Key: DRILL-8529
URL: https://issues.apache.org/jira/browse/DRILL-8529
Project: Apache Drill
Issue Type: Improvement
Components: Query Planning & Optimization
Reporter: Vincent de Gans
Fix For: Future
I propose introducing a caching mechanism for the output of `getQueryPlan()` in
cases where:
- The input SQL query is the same as a previously seen one
- The schema or relevant metadata used for planning has not changed
- The cached result has not expired, based on a configurable time-to-live (TTL)
### Proposed Caching Features
- Toggle to enable or disable query plan caching
- Configurable TTL-based invalidation
- Optional schema metadata verification to detect changes in underlying data
sources
### Motivation
- Reduce planner overhead for repeated queries
- Improve response times in environments where query plans are reused
- Provide an optional optimization that can be enabled when beneficial
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
