Dr R> Could you please explain the relationship (or lack thereof) between ROWLOCKS and the QUALCOLS setting?
Sorry to be dense... wm ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 12:14 PM Subject: Re: ROWLOCKS vs FASTLOCK - Razzak's Reply > > 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. > ==================================-============================= > >
