[GitHub] [shardingsphere] xuejmnet edited a comment on issue #16361: Sequence Query and CircuitBreaker in ShardingSphere

[GitBox <gi...@apache.org>]

xuejmnet edited a comment 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'm not found resort tails 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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org