It also includes URL aliases, web site snapshots and home page locking.
也包括url别名,网站快照和锁的主页。
Better performance for concurrent business queries: Because MDC tables reduce page contention and locking, this also reduces disruption to the performance of concurrent business queries.
并发的业务查询能拥有更好的性能:mdc表减少了页面争用的锁,这一点同时也有利于并发业务查询的性能。
Since we are not manipulating locks ourselves, the engine is locking each row (or page) as it needs it.
由于我们没有操控锁,因此引擎在需要一行(或者页)时会对其进行锁定。
Tables created by Informix default to page-level locking, so when two or more users attempt to update a row on the same page, at least one will get a lock error.
Informix创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).
为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定,我使用了一段sql脚本:genlockmod . sql(参见清单1)。
This script will read the Informix system tables, find out which tables have page-level locking, and then generate another SQL script to change those tables to row-level locking.
此脚本将读取Informix系统表,找出哪些表具有页面级锁定,然后生成另一段sql脚本来将这些表更改为行级别锁定。
Locking escalation to page-level or table-level locking.
从页面级锁升级到表级锁。
Some databases (such as SQL Server) allow you to disable the page-level locking in hopes that it won't escalate from a row-level lock to a table-level lock.
一些数据库(比如sqlServer)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
Locking TLB entries can ensure that a memory access to a given region never incurs the penalty of a page table walk.
锁定TLB输入能确保对于给出区域的内存读取绝不会导致页表移动的掉失。
Locking TLB entries can ensure that a memory access to a given region never incurs the penalty of a page table walk.
锁定TLB输入能确保对于给出区域的内存读取绝不会导致页表移动的掉失。
应用推荐