You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "374639131 (via GitHub)" <gi...@apache.org> on 2023/03/15 05:05:24 UTC

[GitHub] [shardingsphere] 374639131 opened a new issue, #24614: When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index

374639131 opened a new issue, #24614:
URL: https://github.com/apache/shardingsphere/issues/24614

   
   org.apache.shardingsphere
   sharding-jdbc-spring-boot-starter
   5.3.0
   
   ![lhc2](https://user-images.githubusercontent.com/52057252/225211516-6c27a3b9-92ee-4dec-9cea-176f5c5953d8.png)
   ![lhc](https://user-images.githubusercontent.com/52057252/225211536-c67440ba-3885-4ebd-907e-d2724f3aa553.png)
   
   
   When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index。
   
   This will greatly improve the performance
   


-- 
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.apache.org

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

[GitHub] [shardingsphere] 374639131 commented on issue #24614: When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index

Posted by "374639131 (via GitHub)" <gi...@apache.org>.
374639131 commented on issue #24614:
URL: https://github.com/apache/shardingsphere/issues/24614#issuecomment-1469491377

   > you
   
   YES


-- 
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

[GitHub] [shardingsphere] RaigorJiang commented on issue #24614: When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24614:
URL: https://github.com/apache/shardingsphere/issues/24614#issuecomment-1469442683

   @374639131 
   Thanks for your feedback, would you like to submit a PR?


-- 
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

[GitHub] [shardingsphere] 374639131 commented on issue #24614: When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index

Posted by "374639131 (via GitHub)" <gi...@apache.org>.
374639131 commented on issue #24614:
URL: https://github.com/apache/shardingsphere/issues/24614#issuecomment-1469532948

   > feedback
   I want to know why sharding jdbc traverses columns many times？
   


-- 
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

[GitHub] [shardingsphere] 374639131 commented on issue #24614: When routing, first traverse all columns, find the partition key, get the index of the partition key in the set, and get the value of the partition bias according to the index

Posted by "374639131 (via GitHub)" <gi...@apache.org>.
374639131 commented on issue #24614:
URL: https://github.com/apache/shardingsphere/issues/24614#issuecomment-1469534379

   > @374639131 Thanks for your feedback, would you like to submit a PR?
   
   
   > @374639131 Thanks for your feedback, would you like to submit a PR?
   
   
   I found that it takes a lot of time to find the partition key


-- 
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