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/07/02 03:03:53 UTC

[GitHub] [incubator-shardingsphere] fdlzp commented on issue #2624: How should we add index after using sharding-jdbc？

fdlzp commented on issue #2624: How should we add index after using sharding-jdbc？
URL: https://github.com/apache/incubator-shardingsphere/issues/2624#issuecomment-507499344
 
 
   the amount of data：120million
   query sql： above
   
   Average Response Time
   sharding    <  nosharding
   
   after add index
   
   sharding： 700ms nosharding：200ms
   
   and
   ![图片](https://user-images.githubusercontent.com/44960833/60479555-d4d2a180-9cb8-11e9-916e-b14cf70cef03.png)
   
   Is it normal? (Single Database ，multiple tables)
   
   

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