Well, why they don't "prove" anything, they do provide more convincing evidence than the results you mention. They are results comparing the same query, against the same basic dataset, on the same machine hardware/configuration.
You are running the two queries/comparisons on dissimilar machines, and it's entirely possible that something related to the configuration of the machine itself is causing the problems. The very fact that Sara got the results she got is pretty compelling that it IS competitive. As a side note, you've mentioned not understanding why people seem so miffed about your position. Consider that you have come onto the list on a number of occasions, professed to know very little about the product, and then proceed to lambast it in any number of ways. You have questioned the very legitimacy of the product and how anyone could consider it to be useful. Now, consider that you are making these arguments out of ignorance and to a crowd of professionals who have made quite a career/profession out of using the product you find to be fundamentally illegitimate. This doesn't even mention the fact that you call into question the reputation/intelligence of corporations such as Anhaueser-Busch, American Express, and IBM (to name a few) who have production environments running UV. Add to this companies like Datatel, Hughes, and others running UniData. I'm sure the board could list hundreds of other big-name companies using the product, but we won't bother. Ultimately, the U2 products have proven themselves to be very successful. They have, themselves, eclipsed the 1 BILLION in lifetime revenue, and have been the underlying technology used in multiple BILLIONS in overall products in the market today, through the VARs that embed them in their applications. I guess it's just kind of hard to see much of your position holding water based on this... It's not a "have they made as much as the Big Three" argument. It's a "have they been very successful" argument. And, in that argument, the answer is an emphatic yes. -----Original Message----- From: Joe Eugene To: U2 Users Discussion List Sent: 3/30/2004 6:56 PM Subject: RE: Modern Universe (TESTING) 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
