Skip to content
This repository has been archived by the owner on Feb 21, 2022. It is now read-only.

想问下大佬你这查询咋这么快的？ #14

Open
github-plus opened this issue Dec 1, 2020 · 3 comments
Open

想问下大佬你这查询咋这么快的？ #14

github-plus opened this issue Dec 1, 2020 · 3 comments
Labels
question Further information is requested

Comments

@github-plus
Copy link

我的qq表查询一条数据至少需要100秒
@kallydev kallydev added the question Further information is requested label Dec 1, 2020
@kallydev
Copy link
Owner

kallydev commented Dec 1, 2020

文档里写了，加单列索引就行。

@github-plus
Copy link
Author

我用你的创建索引方法，单给第一条就跑了一天一夜了

@kallydev
Copy link
Owner

kallydev commented Dec 1, 2020

我只用了十几分钟，建议你把数据库和临时储存都放在 SSD 上。

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kallydev @github-plus