Avoid database deadlock at insert-operations

[Former Member]

hello,

i have a problem with a high-parallelized (200-300 processes) application/transaction. The application insert entries in a customer defined table. At the insert there are often appear deadlocks, because different processes try to access the table simultaneously.

Exits a possibility to avoid deadlocks?

[Former Member]

hello,

i have a problem with a high-parallelized (200-300 processes) application/transaction. The application insert entries in a customer defined table. At the insert there are often appear deadlocks, because different processes try to access the table simultaneously.

Exits a possibility to avoid deadlocks?

[Former Member]

Are you locking the entire table? If so, try locking just the row(s) you need to update.

Rob