This is what I meant ... TYPO RESULTS
Machine: 950 MHZ Athlon Database: MSSQL SERVER 2K Records: 20 Million Indexes: NO Search Column: First Name Search Type: Wild Card (*) Search Time: 2 Seconds ---------------------- Machine: QUAD Processor Box (4 GHZ) Database: UV Version 10.1 Records: 500,000 Indexes: YES Search Column: First Name Search Type: Wild Card Search Time: 15 - 20 Seconds PICK = A FLAVOR of BASIC...Sometimes called PICK BASIC OR UV BASIC. Call it whatever you want. JOE > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Logan, David (SST - Adelaide) > Sent: Monday, March 29, 2004 8:55 PM > To: U2 Users Discussion List > Subject: RE: Modern Universe - was: The lists are closing > > 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users