You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/01 13:10:39 UTC

[GitHub] [shardingsphere] tuohai666 commented on issue #8457: why sql parse useCache default value is false?

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:
users@infra.apache.org