Re: Deadlock Problem

> If the deadlocks occur because different transactions actually try to
> update the same rows concurrently, then this is an appropriate solution.
> 
> However I wonder if Gavin is getting bitten by foreign key deadlocks.
> Is there any foreign key reference from the stats table to other tables?

Tom,

There are no foreign key references to or from this table as the updates 
to it consume a large % of the overall DB activity so I kept everything 
to a minimum.

I think Csaba has spotted the real problem but given that changing the 
order is not that easy and these stats are not mission critical I may 
just live with the odd deadlock. At least I understand why this is 
happening now.

Thanks,

Gavin