xuejmnet commented on issue #16361: URL: https://github.com/apache/shardingsphere/issues/16361#issuecomment-1078675462
i dont know now `shardingsphere` use which tails comparer,in source code i not found resort before partations,in sequence i think it's very useful. if i'm set maxqueryconnections=1 ```sql select * from order order by time desc limit 1 ``` ### now ```sql select * from order_202201 order by time desc limit 1 select * from order_202202 order by time desc limit 1 select * from order_202203 order by time desc limit 1 select * from order_202204 order by time desc limit 1 ``` we should wait serial query 4 times,i think random sort table tail is bad,some time we should use sequence sort with table tail,and only add circuit breaker we can give up other query -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
