Skip to content
This repository has been archived by the owner on Aug 15, 2020. It is now read-only.

查询速度慢,怎么进行优化 #213

Open
yanhua0 opened this issue Jul 20, 2020 · 0 comments
Open

查询速度慢,怎么进行优化 #213

yanhua0 opened this issue Jul 20, 2020 · 0 comments

Comments

@yanhua0
Copy link

yanhua0 commented Jul 20, 2020

Question

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant