tuohai666 opened a new issue #9826: URL: https://github.com/apache/shardingsphere/issues/9826
After analyse I found there're redundant and costly instance initialization in the key path. It's not necessary to initialize the stateless instances in the prepare/route/rewrite/merge process for every SQL query each time. To improve the performance we can cache these instances. After test, the CPU load decreased by 60% and the TPS of sysbench test result increased by 15% . -- 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. For queries about this service, please contact Infrastructure at: [email protected]
