Re: Informix, Sybase, Oracle or MS SQL server
Date: 1996/04/25
Message-ID: <4loqhk$blp_at_zk2nws.zko.dec.com>#1/1
In article <4llgt5$7ob_at_netope.harvard.edu> cpc0000_at_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!
Received on Thu Apr 25 1996 - 00:00:00 CEST