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
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

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

Reply via email to