RE: Worlds largest Data Warehouse ?

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Fri, 19 Oct 2007 09:01:06 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA9087BB631@UNIMAIL.staff.ad.cqu.edu.au>

Actually it has a lot to do with Oracle, Yes So what Sybase could load a very big DW, what they dont show is when they were doing the queries, what was there transaction isolation level. Default of SQlRemeber that due to the infinitely different locking mechanism that they would have likey needed to set transaction read uncommitted to be able to get performance in this case. SQL Server during updates doesn't use omly row level locking, due the its behaviour, it may eventually escalate to a

From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Friday, 19 October 2007 07:35 AM
To: rajendra.pande_at_ubs.com
Cc: exriscer_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Worlds largest Data Warehouse ?

Whats the point you are trying to make? And what has it got to do with Oracle?

On 18/10/2007, rajendra.pande_at_ubs.com <rajendra.pande_at_ubs.com> wrote:

No look at the document at
http://www.sybase.com/files/Product_Overviews/Ready-Time-Report_R1.2-090 407.pdf

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 18 2007 - 18:01:06 CDT