Re: Comparing RDBMS engines

} } > Comparing Database Engines } > ========================== } > Sybase SQL Server 10 } > -------------------- } > ... } > Microsoft SQL Server 6 } > ---------------------- } > ... } } According to the best of my knowledge both these servers do not support record } level locking. This is a major weakness in online transaction systems. I can } therefore not recommend these servers to our clients. } } Theo } Why is row-level locking so important? Page level locking is very efficient. Furthermore, doesn't Online lock the entire page in a DML transaction? Every case of contention that I have encountered was better addressed by spreading out the updates instead of increasing the granularity. I would appreciate further discussion on this topic. -- chuckg@NeoSoft.com "An egg's in the plan" -- M. Mothersbaugh