Sara, Were server loading issues the same between your queries? Were both DB's online and active during the queries? Same number of users? same time of day, etc.
As an interesting academic exercise would it be possible to run after hours tests by pausing UV during the Oracle query and whatever the Oracle's equivalent is (quiescent) during the UV's query? It might also be helpful to run the same query a few times to produce an average time for query. You'll also need to address any lingering memory and temp space traces of the files between tests (logging off between tests might do that, not really sure on that one...) Eric Y. Neu Sr. Programmer Analyst Zetron, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joe Eugene Sent: Tuesday, March 30, 2004 3:07 PM To: U2 Users Discussion List 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
