The size of the lock table can be increased by changing
this parameter in the firebird.conf file:

# Bytes of shared memory allocated for lock manager.
# In Classic mode, the size given is used for the initial
# allocation. The table expands dynamically up to the
# limit of memory. In SuperServer, the initial size is
# also the final size.
# Default is 96K on Linux and Solaris, 256K on Windows.
#
# Type: integer
#
#LockMemSize = 262144

remove the leading '#' in the last line and double
or quadruple the value. The number is in bytes, so
you're not going to use much memory on a modern machine.

You should also increase the width of the lock hash table,
in the entry below. Pick a prime number between 211 and
503 - lower if you double the table, higher if you quadruple
it.

#
# Tune lock hash list; more hash slots mean shorter hash chains. Only
# necessary under very high load. Prime number values are recommended.
#
# Type: integer
#
#LockHashSlots = 101


Regards,


Ann