At 10:28 AM 10/5/2001 -0700, Bernie Corrigan wrote:
>Can someone tell me the functional difference between
>ROWLOCKS and FASTLOCK?
Bernie,
Here you go ...
01. ROWLOCKS (Default: ON)
FASTLOCK (Default: OFF
02. ROWLOCKS only locks the required row for the current
command instead of locking the entire table.
FASTLOCK, when ON, speeds Multi-User performance while
modifying data and does not place lock on the table,
allowing for greater throughput.
03. ROWLOCKS ON does not require STATICDB ON
FASTLOCK ON requires STATICDB ON.
04. ROWLOCKS can be turned ON or OFF after CONNecting the
database.
FASTLOCK can only be turned ON before STATICDB is set
to ON and CONNecting the database.
Typical Example:
SET STATICDB ON
SET FASTLOCK ON
CONNECT Database
05. In a Multi-User environment, ROWLOCKS can be SET to
ON or OFF by individual user(s).
In a Multi-User environment, FASTLOCK setting must
match for ALL users of a database and must be set
before a database is connected. Users cannot connect
a database unless their FASTLOCK setting matches the
setting of the open database, similar to STATICDB,
MULTI and TRANSACT.
Having the STATICDB ON, FASTLOCK ON and QUALCOLS 2 is
the fastest method for updating data in a Multi-User
environment.
06. ROWLOCKing is used when working with a Form or in a
BROWSE/EDIT mode - just a single row of data is
modified at a time.
Commands such as UPDATE, INSERT and DELETE perform
much faster with FASTLOCK set to ON.
There you have it ...
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
