Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

sqlite count(*) 慢，如何优化？Navicat 是如何优化的？

0 votes
3.9k views
in Technique[技术] by (71.8m points)

sqlite count(*) 慢，如何优化？Navicat 是如何优化的？

sqlite 单表百万级数据，发现用了 count(*) 就会很慢

但是 一样的查询语句， 用 Navicat 居然查询的很快

请问这是为什么呢？？ Navicat 是如何优化 count(*) 查询的呢？


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Navicat作为一个客户端根本没有优化查询的能力，它仅仅无脑将查询发送给sqlite，因此你的提问是不成立的


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

Just Browsing Browsing

2.1m questions

2.1m answers

60 comments

57.0k users

Most popular tags

Powered by Question2Answer
Donate
Theme by Q2A Market&&OStack.cn
...