youjie23 opened a new issue, #34155:
URL: https://github.com/apache/shardingsphere/issues/34155
   ## Feature Request
   
   Add `SQLStatementParserCacheHook `to Provide Extension Point for Application 
SQL Parse Cache Warm-up, Referred to as Preheat
   
   ### Is your feature request related to a problem?
   #24744  #3676  #4480 #5209 #2793 #3083 
   
   ### Describe the feature you would like.
   We propose adding a `SQLStatementParserCacheHook ` that serves as an 
extension point, allowing business applications to capture cache-missed 
compiled SQL statements. This mechanism is designed to enable application 
developers to use these captured SQL statements for parse cache warm-up before 
the actual user requests occur.
   
   - **Objective**: Facilitate application-level SQL parse  cache warm-up to 
improve performance on initial queries.
   - **Implementation**: Introduce a hook that business logic can subscribe to, 
which triggers when there is a cache miss during SQL statement parsing. The 
hook should provide access to the missed SQL statement for external processing.
   - **Benefit**: Developers can preemptively compile and cache SQL statements 
in their applications, reducing the latency experienced by users on their first 
interaction with the system.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to