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 2020/07/20 01:19:32 UTC

[GitHub] [shardingsphere-example] yanhua0 opened a new issue #213: 查询速度慢，怎么进行优化

yanhua0 opened a new issue #213:
URL: https://github.com/apache/shardingsphere-example/issues/213


   ## Question
   
   目前我是5亿数据用shard-jdbc做的分库分表查询，执行全表路由查询时间为2分钟左右,但是我在数据库执行单条sql语句查询时间为1s左右返回，问下框架做select count(id) from table时，拆分的sql语句是并行执行的吗?有办法可以优化下查询速度?我修改了shard-jdbc工作线程查询速度也没有影响


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