tuohai666 commented on issue #8457: URL: https://github.com/apache/shardingsphere/issues/8457#issuecomment-736541693
Statement will not be cached while PreparedStatement will be cached. Why Statement will not be cached? Imagine I insert rows whose id is from 1~1000000, all the 1000000 SQLs are different and the cache will not work. Why PreparedStatement cache works? Imagine I insert rows whose id is from 1~1000000, **id = ?** will be cached and is the only SQL to be cached. All the 1000000 SQLs share one parse result. ---------------------------------------------------------------- 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]
