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
RE: Modern Universe (TESTING)
Well, my understanding of the query used was a single key field query based on an indexed key. This would involve simply reading the index entry, and then doing hash reads on the records contained in that index key. When sorting, at least on some systems, we do have a parallel/threaded sort engine to perform a merge-sort similar to what you describe. Just didn't seem that this called for such a need. Dave -Original Message- From: Robert Colquhoun To: U2 Users Discussion List Sent: 3/30/2004 7:01 PM Subject: RE: Modern Universe (TESTING) Hello Dave, At 09:36 AM 31/03/2004, [EMAIL PROTECTED] wrote: 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. Just curious about the above - why does it have to be that way? You are reading in groups one at a time and then merging them into the main list. Surely you can have at least one thread read in the records(as this takes a long time) and at least one other do an insertion sort on the group and a merge sort on the main list simultaneously. If you use a merge sort you should be able to break it into how many ever processors are available then merge each processors final sub-list together to get the result. - Robert -- 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
RE: Modern Universe (TESTING)
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
RE: What are embedded databases
Well, not sure about 10 words or less, but here's my effort: An embedded database is a technology that is deployed as the component responsible for data management within a business application. Dave -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 3/29/2004 2:18 PM Subject: Re: What are embedded databases In a message dated 3/29/2004 11:55:51 AM Eastern Standard Time, [EMAIL PROTECTED] writes: embedded data base support The other day, someone asked me if I used an embedded database. And I was like ... what? Can someone give ten words or less of what an embedded database is? And then maybe an example of a database that is NOT embedded? Thanks Will -- 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
RE: What are embedded databases
Yep... Very true... Dave -Original Message- From: Stevenson, Charles To: U2 Users Discussion List Sent: 3/29/2004 4:44 PM Subject: RE: What are embedded databases An embedded database is a technology that is deployed as the component responsible for data management within a business application. Dave The other day, someone asked me if I used an embedded database. So most of this list's members probably don't *use* an embedded database, but rather they are in the business of embedding one into their own application. And when they do, I guess they turn RetrieVe or UniQuery into an Embedded Reporter, eh? -- 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