Thank you Sara for giving us the real facts (and just the facts). Seems this should put the arguement to bed unless someone has some other real FACTS.
It begs the question, however, as to why Oracle is used at all, ... being three times slower that is. Patrick "Will" Williams, President American Computer Technics, Inc. 919-567-0042 Raleigh, NC ----- Original Message ----- From: Sara Burns To: [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 1:02 PM 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