Mysql with nolock 查询
MySql
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM TrackingSupplierInfo order by CheckingTime desc limit 10000;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SqlService SELECT top 10000 * FROM TrackingSupplierInfo WITH(NOLOCK) order by CheckingTime desc;温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/15629.html
- 上一篇：zabbix的数据库优化
- 下一篇：mysql-哈希索引
