Dave,

Just thought you'd like to know that multi-threaded sorting is available
(via a uvconfig parameter) in 10.1.

Regards,

LeRoy F. Dreyfuss
Advanced Technical Services - UniVerse
IBM U2 Data Management Solutions
Tel: 303-672-1254          Fax: 303-294-4832
Mobile: 720-341-4317
External email:  [EMAIL PROTECTED]
WWW:  http://www.ibm.com/software/data/u2/support

www.ibm.com/software/data/u2/support - Open, Query, Update, Search -
Online!


                                                                       
             [EMAIL PROTECTED]                                         
             ialsoftware.com                                           
             Sent by:                                                   To
             u2-users-bounces@         [EMAIL PROTECTED]             
             oliver.com                                                 cc
                                                                       
                                                                   Subject
             03/30/2004 04:36          RE: Modern Universe (TESTING)   
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
                 U2 Users                                              
              Discussion List                                          
                                                                       
                                                                       




 I think the results point out the fallacy of your arguments.  It shows,
pretty definitevly, that UV can and does perform as well/better as Oracle,
albeit under certain circumstances (ie, I'm sure other kinds of queries
could produce different results).  It doesn't mean you will always get
better performance, but rather, it offers competitive performance (better
for some things, worse for others)

 However, one thing I did want to address is your QUAD processor point.
You've made it a few times, and I just had to point out that it is
irrelevant to the discussion.  While UV will take native advantage of
multi-processors in it's execution, a single query executed by a single
user, especially such as that listed, will execute on a single processor,
so
no benefits will be seen for being on a QUAD (or a 64-way) machine.  So, in
reality, you are talking about the performance equivalent of operating on a
single processor machine of whatever rating it has (and obviously, memory,
other applications running, etc... impact that)

 Dave



-----Original Message-----
From: Joe Eugene
To: U2 Users Discussion List
Sent: 3/30/2004 6:07 PM
Subject: RE: Modern Universe (TESTING)

Sara,

Can you please post your Query and results... Cause I am seeing the
EXACT Opposite...as I posted earlier.

Oracle Query is what?
Select firstName from Customers where firstName like 'Sar%';

The above takes about 7-9 Times More Time to get any results on Our UV
QUAD PROCESSOR MACHINE.

Please post your PICK/BASIC Statement.

Also you might want to dump the data in a separate table... other than
something you use for other things.

Thanks,
Joe Eugene


> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
> Behalf Of Sara Burns
> Sent: Tuesday, March 30, 2004 4:03 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Modern Universe - was: The lists are closing
>
> I am probably in the best position to compare apples with apples.
> I have both UniVerse and Oracle on the same IBM p660 4 processor box
with
> 6Gb RAM.  The 800,000 customers are replicated from UniVerse to
Oracle,
> although the Oracle version is only a subset of the attributes
required by
> a
> different application.
>
> Both have an index on the first line of the Postal Address.
>
> My query was to show all customers with the first line of the Postal
> address
> like %EXPLORATION
>
> Results:-
> UniVerse 9 seconds
> Oracle 25 seconds
>
> Sara Burns
>
>
> Sara Burns (SEB)
> Development Team Leader
>
> Public Trust
> Phone: +64 (04) 474-3841 (DDI)
>
> Mobile: 027 457 5974
> < <mailto:[EMAIL PROTECTED]>
> mailto:[EMAIL PROTECTED]>
>
> Information contained in this communication is confidential. If you
are
> not
> the intended recipient the information should not be used, disclosed,
> copied
> or commercialised. The information is not necessarily the views nor
the
> official communication of Public Trust. No guarantee or representation
is
> made that the communication is free of errors, virus or interference.
>
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to