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