Are you ever going to just go away..........!  So sick of this
discussion!

>>> [EMAIL PROTECTED] 3/30/2004 3:56:28 PM >>>
Dave,

> I think the results point out the fallacy of your arguments.  

The results Sara posted here does NOT Prove anything, cause my results
show the EXACT Opposite.

So the deciding factor is to analyze what Sara wrote to come up with
the results she posted

Again post the code!

Here is my code on MS SQL-SERVER that returns a resultset.
Select firstName from Customers where firstName like 'Sar%';

<RESULTS>
Machine: 950 MHZ Athlon
Database: MSSQL SERVER 2K
Records: 20 Million
Indexes: NO
Search Time: 2 Seconds

What is your code on UV that returns the above results?

If you can prove that UV Comes back in 5 Seconds under the above
Conditions...I would be most happy to agree that UV is Competitive.

Thanks,
Joe Eugene



> -----Original Message-----
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
On
> Behalf Of [EMAIL PROTECTED] 
> Sent: Tuesday, March 30, 2004 6:36 PM
> To: [EMAIL PROTECTED] 
> Subject: RE: Modern Universe (TESTING)
> 
>  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
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to