If your component uses the Adaptive Server Enterprise with the Sybase identity column type, make sure the relevant database and table options are tuned, such as the identity burning set factor database option or the identity_gap table creation parameter.
If your component uses automatic key generation with a key-lookup table, tune the key batch size value. To prevent different threads from creating duplicate keys, EAServer uses a semaphore to synchronize the key increment operation. Each thread reserves the specified number of key values per increment. The key use rate can be tuned to reduce inter-thread contention for locks on the key table. A value of 100 results in good performance for most applications. Large batch increment values can result in large gaps between key values. Gaps in the key sequence are possible if the key use rate is greater than 1.