Joe Have you sized your UV file correctly? The 15-20 seconds suggests many things are not as they should be.
Can you do an "ANALYZE.FILE" on this file and post the details. If it is a dynamic hashed file include the option "STATS" please. We may be able to help you after all. Cheers Trevor Ockenden OSP ----- Original Message ----- From: "Joe Eugene" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 12:06 PM Subject: RE: Modern Universe - was: The lists are closing > 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 > --- 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
