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?