If deadlocks are creating problems, consider converting the table to use datarows locking.
If deadlocks or excessive numbers of locks are creating problems, consider using the lock table command to acquire an exclusive table lock before you begin the transaction.
