Re: SQL Server vs INFORMIX

>>>>> ""Billy" == "Billy Wheeler" <billy@west.co.za> writes: Billy> Billy> Some notes on this: Billy> 1. Richard also forgot the problem applies to Billy> INSERTs, which in an OLTP system can be even worse. Billy> 2. RDBMS's which don't support row level locking Billy> *do* all suck. 3. It wasn't really a deliberate Billy> decision to apply page level locking for Billy> performance, I just forgot to alter the tables after Billy> our initial dbexport/dbimport. Billy> One question: who owns the current TPC-C record? I'll make it easier for you: it's not Informix nor Oracle.... and they do page level locking. -- Pablo Sanchez | Ph # (650) 933.3812 Fax # (650) 933.2821 pablo@sgi.com | Pg # (800) 930.5635 -or- pablo_p@pager.sgi.com ============= Please include "not spam" in your "Subject: " line ============== I am accountable for my actions. http://reality.sgi.com/pablo [ /Sybase_FAQ ]