Re: Informix, Sybase, Oracle or MS SQL server

In article <4llgt5$7ob@netope.harvard.edu> cpc0000@ibm.net writes: > > ... For quick update, transaction >type systems, it works OK, but I've done some compute intensive data >warehousing operations, and for this it can be troublesome if you hold locks >for a long time. For data warehousing operations, you often can get away with no locking for read. Both Sybase 10 and 11 support 'nolock' option in SELECT. So this is not a problem. Even with locking, as long as page locks do not get promoted to table lock and thus lock up the entire table, it is not a problem in data warehouses. Sybase 11 allows the DBA to control when the page locks get promoted to table lock. So, even with locking, this is not a problem in Sybase 11. Paul Chen, Ph.D. Consulting at DEC Disclaimer: My opinions only!