The most efficient locking strategy is to turn off page and row locking and allow all concurrent readers to get a shared (S) lock on the table, reducing overhead.

• 最有效的锁定策略是关闭页锁定和行锁定,并允许所有并发读取器获得表上的共享锁(S锁)以减少开销。