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 2019/10/25 02:30:56 UTC
[GitHub] [incubator-shardingsphere] duanbin0414 opened a new issue #3366:
Sharding-jdbc execute sql, in(x, x, x) performance issues
duanbin0414 opened a new issue #3366: Sharding-jdbc execute sql, in(x,x,x) performance issues
URL: https://github.com/apache/incubator-shardingsphere/issues/3366
version 4.0.0-RC1
when execute
Condition condition = new Condition(User.class);
ArrayList<String> billCodes = new ArrayList<>();
billCodes.add("13");
billCodes.add("14");
condition.createCriteria().andIn("id", billCodes);
only need to query two tables from two database, but actually calculate four tableUnits to execue.
two additional tables were queried.
Is there a problem with this performance loss?
Whether the data query table relationship can be maintained and executed precisely?
----------------------------------------------------------------
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
With regards,
Apache Git Services