V3.0还引入了非阻塞查询,使用存储在"Before Image"文件中的数据来查询和回滚事务,从而避免了读取锁(read lock)的使用。另一个技术是“簇/Clustering”,能实现在同一物理块里存放来自不同表的行记录。
基于20个网页-相关网页
通过此策略,由于您未对数据保持读取锁,因此在执行更新操作时遇到失效数据异常的机率会增加。
With this strategy, because you are not holding read locks on data, the chance of getting stale data exceptions when you execute the update operations increases.
悲观会话锁通常为写入锁,它们允许其他用户读取锁定的数据,除非遇到不能读取的情况。
Pessimistic session locks should generally be write locks; they should let other users read the locked data, unless there is a very strong case to not do so.
事务1读取某条特定记录并对该行应用一个锁。
Transaction 1 reads a specific record and places a lock on that row.
应用推荐