Allowing or disallowing row-level locking affects database performance.
允许或禁用行级锁定会影响数据库性能。
The header is used to link together consecutive records, and also in row-level locking.
这个头是用来连接连续的记录,也用于行级锁。
The first thing every contestant needed to do was change every table to row-level locking.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
在导出操作期间,行级别锁定应用于导出表(exportingtable),这意味着一次只持有一个锁。
WebSphere Process Server accesses its databases in multiple concurrent threads and USES row-level locking to ensure data consistency during its transactions.
WebSphereProcessServer通过多个并发线程访问其数据库,并使用行级锁定来确保其事务期间的数据一致性。
In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
实际上,在INSERT期间惟一保持的行级锁是next - key锁,这个锁用于使INSERT不会添加键到可重复的读扫描器。
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脚本来将这些表更改为行级别锁定。
For MDC tables, the selection of BLOCKINSERT may improve the performance of INSERT operations by locking at the block level and avoiding row locks for INSERT operations.
对于mdc表,选择BLOCKINSERT可以提高INSERT操作的性能,因为使用的是块级的锁,避免了为INSERT操作使用行锁。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
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创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
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)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
If table locking is not used, the default USES row - level locks, unless the.
如果未使用表锁定,默认使用行级锁定,除非。
If table locking is not used, the default USES row - level locks, unless the.
如果未使用表锁定,默认使用行级锁定,除非。
应用推荐