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
