QUALCOLS

Operating Condition

Syntax: SET QUALCOLS (2 or 10)

Mode: Multi-user

Default: 10

Use QUALCOLS to choose page or row locking. The settings for QUALCOLS are:

·

2 - R:BASE uses a fast row-locking method. When QUALCOLS is set to 2, you can lock rows of data instead of locking a page of data. You increase multi-user performance when QUALCOLS is set to 2 and STATICDB and FASTLOCK are on.

·

10 - R:BASE uses page locking. When QUALCOLS is set to 10 and two or more users are updating rows within the same page of data, R:BASE only lets the first user update rows--the other users are locked out until the first user's update has been completed.

Note: QUALCOLS is not the same as SET ROWLOCKS. ROWLOCKS and QUALCOLS can be set on at the same time.

The following command line sets QUALCOLS to 2:

SET QUALCOLS 2