Hi Joe, Perhaps you could share your actual searches, code and database structure? Were you searching 20 million records in a single column table? Multiple "fields (or columns if you insist)" in the Universe database? What is this PICK you keep talking about? Universe doesn't have a component named PICK, there is certainly a flavour. That is your choice to use it, you are not compelled to.
How do we know you are comparing apples with apples? How were your indexes structured? I haven't seen "Universe Standards" for indexing. Please elucidate on this as I am obviously ignorant in this area. Unfortunately your claims are now starting to fluctuate between the fantastic and the ludicrous. How can you expect to be taken seriously when you don't provide a sound basis for your argument? I presume you meant the first database to be Universe? Obviously it must be as it was the fast one 8-) Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Eugene Sent: Tuesday, 30 March 2004 11:17 AM To: U2 Users Discussion List 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users