Re: Informix, Sybase, Oracle or MS SQL server

chen_p_at_perfit.zko.dec.com (Paul Chen) wrote:

>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.

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_at_a1.tch.harvard.edu
Applications Specialist        Portal:  cpc_at_shell.portal.com
Children's Hospital            Home:    cpc0000_at_ibm.net