Joe I do not have access to a file with 20 million records but I will create one with random data and try to carry out your test. Bare in mind I will be using my laptop (NEC Versa LX P2 366 - 384Mb RAM and relatively slow disk) which may sku the results somewhat but I will do my best to tune UV to get satisfactory results.
With luck and in between picking up the kids etc. I should have a result by tomorrow (as it is nearly knock off time Down Under). I would be interested to know if you could create the environment from scratch to carry out this test as I am intending to do? How long would that take you? For your interest, whilst I was typing this e-mail my program to create the data has already created 1 million records. It took approximately 5 minutes to write. Compiled first time. I also have [EMAIL PROTECTED] running, plus 10 other windows open. Total memory usage is 244Mb on Win2000. Cheers Trevor Ockenden Open Systems Professionals ----- Original Message ----- From: "Joe Eugene" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Wednesday, March 31, 2004 3:30 PM Subject: RE: Comparing Oracle with UV > > 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 > --- 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