tuohai666 commented on issue #9616: URL: https://github.com/apache/shardingsphere/issues/9616#issuecomment-809967931
@jackjoesh You are right, I understand your concern. PreparedStatement will be cached in a LRUCache, the cache will finally reach the prepStmtCacheSize if there're so many different SQLs. I think big prepStmtCacheSize is appropriate for ShardingSphere scenarios which contain so many shardings(means so many different SQLs). Maybe we should make this parameter customized like username/passwordconnectionTimeoutMilliseconds etc. I suggest that the default value to be big enough. If the users occur memory problems, they can turn down this parameter. Are you interested in submitting a PR? -- 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]
