tuohai666 opened a new issue #9616:
URL: https://github.com/apache/shardingsphere/issues/9616


   For now the prepStmtCacheSize is 250. Much more time will be cost when the 
prepared statements count is over this size. The effect is significant.
   
   
![image](https://user-images.githubusercontent.com/24643893/110457440-9afca400-8105-11eb-92c5-b395a4357a7b.png)
   
   If a preparedStatement is removed from the cache, the following same SQL 
needs to prepare again. Both the **Request Close Statement** and the new 
**Request Prepare Statement** are additional cost compare with the single 
**Request Execute Statement**


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


Reply via email to