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