Re: Informix, Sybase, Oracle or MS SQL server

chen_p@perfit.zko.dec.com (Paul Chen) wrote: >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. Okay, I stand corrected. I'm not all that familure with Sybase 11; most of my experience with the Sysbase RBMS was during the 9->10 transitional phase. I do however know Oracle. Thanks for the info! Chris ===================================================================== Chris Cebelenski CH: cebelenski@a1.tch.harvard.edu Applications Specialist Portal: cpc@shell.portal.com Children's Hospital Home: cpc0000@ibm.net #include <std_disclaimer.h> Wk Phone:(617) 355-8401