Joe Have I missed something here. You refer to the QUAD as having MSSQL SERVER 2K as the database so where does the UV (or PICK) files fit into this equation?
Also, when carrying out this performance test did you take into account as to whether or not the file was in memory or not. The Athlon may have had most of the table concerned in memory whilst the Quad may have had to load the whole (Pick) file into memory. Let's be fair here. If you want to do a fair comparison I suspect you will need to go to a little more trouble. I have run a similar test on my Pentium 2 366 laptop running UV and a 500,000 record file can be searched (wild card - ie no index used) in much less than 15 seconds. Have another try! Cheers Trevor Ockenden OSP ----- Original Message ----- From: "Joe Eugene" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 11:47 AM Subject: RE: Modern Universe - was: The lists are closing > Charles, > > Our Customer Information is stored in UV and accessed via PICK. > This FILE (as UV ppl call it) contains around 500,000 Records in it. > Everything is INDEXED Per UV Standards. > > Here is simple WILD CARD Search Test. > > RESULTS > > Machine: 950 MHZ Athlon > Database: MSSQL SERVER 2K > Records: 20 Million > Indexes: NO > Search Time: 2 Seconds > > ---------------------- > > Machine: QUAD Processor Box (4 GHZ) > Database: MSSQL SERVER 2K > Records: 500,000 > Indexes: YES > Search Time: 15 - 20 Seconds > > I had to Increase the Time out on application servers to support MR.SLOW > UV! > > How do you think I am supposed to believe UV Performs Well. > > Thanks, > Joe Eugene > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On > > Behalf Of Results > > Sent: Monday, March 29, 2004 8:06 PM > > To: U2 Users Discussion List > > Subject: Re: Modern Universe - was: The lists are closing > > > > Joe, > > Here's a few things to consider. MV environments (including > > UniVerse), allow for small teams to develop and adjust business rules > > more quickly than you can you can in Oracle, Sybase, or Informix. > > Published statistics show that MV environments are roughly twice as > > efficient in disk usage (smaller footprint means faster searches - > > forget the 'who cares, disk is cheap' argument, search speed is always > a > > premium issue). MV environments are typically three times as efficient > > on CPU and memory usage. That means that a given system running an MV > > environment is triple the speed of a "Big Three" database even when > you > > ignore search speed. > > Also, since Datastage is one of the best data warehousing systems > in > > the world (and it has a common ancestry to the U2 technology), you can > > be assured that MV environments make excellent data marts, data > > warehouses, and data repositories. Informix bought the U2 technology > > just to get Datastage. > > > > -- > > > > Sincerely, > > Charles Barouch > > www.KeyAlly.com > > [EMAIL PROTECTED] > > > > > > > > -- > > 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: 24/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
