相同环境下，用 sqlite 查询只需要十几 ms
This topic created in 2019 days ago, the information mentioned may be changed or developed.
 |
0ZXYDDu796nVCFxqApr 26, 2021 via Android
1
id 是主键吗？如果不是那有没有索引？
|
 |
keepeyeApr 26, 2021
2
mysql 负载太高了吧
|
 |
ch2Apr 26, 2021
3
改参数，把 cache 大小调低
|
 |
4
是特定的某张表查询会这样，无论是索引不索引的语句都很慢。其他表正常
|
 |
xmh51Apr 26, 2021
5
看下表的锁状态
|
Select Language