qwaszx92717 opened a new issue #8528: URL: https://github.com/apache/shardingsphere/issues/8528
When using “in” query, and the parameters have thousands of “ID”, the query speed will be very slow. Use "_+partitioned " query speed is normal. Here are some configuration data and troubleshooting data. config  query sharding log  testing environment 1.using sharding、50w data、sql:select * from table where column in (...)、condition have index, not shardingid. query time 15s 2.not used sharding，ditto. query time less 0.2s ---------------------------------------------------------------- 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]
