Re: Comparing RDBMS engines

chuckg@Starbase.NeoSoft.COM ("Chuck G.") wrote: >..... >e not recommend these servers to our clients. >} >} Theo >} > >Why is row-level locking so important? Page level locking is very >efficient. IMO Row-Level locking becomes important when hot-spots in an application are localized to one or few tables. If these tables are small in terms of number of rows, then the contention becomes a major issue. >Furthermore, doesn't Online lock the entire page in a DML >transaction? > No. It does not. Depends on the lock mode specified at table creation time. >-- >chuckg@NeoSoft.com "An egg's in the plan" -- M. Mothersbaugh