R:BASE is a multi-user system that can be used in single-user mode, which prevents other users from connecting to the database. Purpose of operating in single-user mode would be for a database administrator to perform structural changes or maintenance.
To operate in single-user mode:
1.Have all users disconnect from the database.
2.Enter SET MULTI OFF at the R> Prompt.
3.Reconnect one user to the database.
Increase Single-User Performance
If you do a process in a single-user environment, you will improve performance by using SET CLEAR OFF before executing commands that change or add rows to the database. SET CLEAR OFF sets up a 5K buffer to hold changes. Changes are written to disk when you SET CLEAR ON, when the buffer is full or is needed for the next page of data, or when you disconnect the database or exit from R:BASE. CLEAR can be set differently by individual workstations and is ignored in multi-user mode.
