Trevor, I will try to do this "ANALYZE.FILE STATS" sometime tomorrow. Again... Nobody here has come up with any real proof of any clear testing results...other than just sending out useless random emails.
I provided the exact details on my testing, can you do me a BIG Favor. Do you have any UV DataBase that Contains around 20 Million Records? Can you do a CASE IN-SENSITIVE Search against ONE Field in UV FILE/TABLE and post the real time average results? I belive the syntax UV uses for WILD CARD Search is "]" I simply cannot even come with a Seconds Timing againt less than 1 Million Records in MS-SQL Server with NO Indexes, which proves very good performance. I have never seen this Kinda Good Performance in any UV Programs/Against any UV Files within UV/PICK/BASIC. Thanks, Joe Eugene >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of Trevor Ockenden >Sent: Tuesday, March 30, 2004 11:26 PM >To: [EMAIL PROTECTED] >Subject: Comparing Oracle with UV > > >Joe > >As this comparison is still raging why don't you do the >ANALYZE.FILE STATS for us and post the results as my experience >has shown that 9 times out of 10 performance is related to file >sizing. A fundamental element of setting up any database. > >Note, we all stand to learn something here. > >Cheers > >Trevor Ockenden >Open Systems Professionals >M: +61 414 731 634 >E: [EMAIL PROTECTED] > > >--- >Outgoing mail is certified Virus Free by AVG 6.0. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.642 / Virus Database: 410 - Release Date: 25/03/2004 >-- >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
