Subject Fwd: How to avoid deadlock ?
Author Vander Clock Stephane
Hello,

say we have one table Data and one Table Stats

Table_Data
ID
1
2
5
8


Table_Stats
NB_IDs
4

everytime one user add or delete one row in
Table_Data, then trigger will update the
table_stats (NB_IDs) by increasing or decreasing
the actual number in it

several user can update different row at the same in
table_data

how to avoid deadlock when the trigger update the NB_Ds
in table_stats ? what mechanisme to use ?

thanks by advance
st├ęphane