Hi :
     we have  a table 'member' with 160,000,000 rows ,

      sharding key is member_id
     after sharding the database to 16 databases, the 'member' 's table struct 
is same in 16 databases,
one database the 'member' table have 10,000,000 rows

     we   query  data by SQL "select * from member where member_id = 'abc' "  
on   database 1 ,it cost 8s,


   when i used proxy query on  16 databases by the same sql ,  it  cost  60s ,  
as far as I know the proxy used threadpool to Parallel execution the query , 
but  the query is slow , why?


Reply via email to