Use an appropriate lock type

When using table or record locks, it is important that you only take what is required by the operation you are performing on the database. For example, if you are modifying a key field, or deleting or updating a record, you must ensure that a write lock is used on the table. Additionally, if you are modifying any fields on a record, you must ensure that you have a record write lock.

Use locks for the shortest time possible to ensure that you are not unnecessarily blocking other readers or writers at the same time.