The PAGELOCK setting is used to turn page locking off and use row locking only. If you know that your application mainly updates or deletes data a row at a time, rather than many rows, SET PAGELOCK OFF for row locking. The valid settings for PAGELOCK are:
•ON - page locking or row locking as appropriate.
•OFF - row locking only, no page locking. R:BASE locks a row, reads the row, makes the change and then releases the row.
The fastest method for updating data in multi-user mode is STATICDB ON, FASTLOCK ON, PAGELOCK OFF. This group of settings results in the fewest contentions between users. PAGELOCK can be changed during an application and can be different for different users of the same database. Otherwise, set PAGELOCK ON for page locking when you are doing an UPDATE and/or DELETE affecting many rows in a table.
