Home
Sign Up
Sign In
V2EX
›
问与答
一个定时任务中 sql 的 count 次数过大,该怎么解决
maguazhou
·
Feb 12, 2019
· 2352 views
This topic created in 2838 days ago, the information mentioned may be changed or developed.
运行不超过几分钟服务器就报警
count
SQL
定时
次数
1 replies
•
2019-02-12 15:10:50 +08:00
NjcyNzMzNDQ3
Feb 12, 2019
1
1
1.explan 优化查询范围,使用索引。
2.cont 查询使用非主力库。
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Privacy
·
Solana
·
2219 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 26ms ·
UTC 11:02
·
PVG 19:02
·
LAX 03:02
·
JFK 06:02
♥ Do have faith in what you're doing.
❯