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;
posted on 2019-12-13 11:40  jeffh  阅读(6274)  评论(0编辑  收藏  举报