Re: SQL Server vs INFORMIX

Posted in 1997

Richard Stanford — Wed, 8 Oct 1997 12:58:57 -0500 — source: Informix-list mailing list archive (1991-1998)

> >>>>>> ""Billy" == "Billy Wheeler" <billy@west.co.za> writes: > >Billy> 1. Richard also forgot the problem applies to > >Billy> INSERTs, which in an OLTP system can be even worse. Actually, SQL server supports row-level for inserts. Odd, eh? It just tended to exasperate our problem, since the deadlock-inducing SPs were kicked off by triggers on inserts. Go fig -- slowing down the inserts with locking problems actualleped up our overall system by reducing the number of deadlocks. -Richard