Trevor, Sorry.. that was a TYPO.. I Re-Posted the Performance Results. Everybody here thinks I am just bringing up things for FUN!.
These are Real world, Real Time applications. I have never worked With any database where I had to Increase the Application Server Timeout Cause Users were getting Request Time out Errors from the DB. I can post JRUN LOG Files here where UV took more than 3 Minutes to Process Requests. I can't believe people on this LIST get so Defensive. Thanks, Joe Eugene > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Trevor Ockenden > Sent: Monday, March 29, 2004 9:10 PM > To: U2 Users Discussion List > Subject: Re: Modern Universe - was: The lists are closing > > 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users