Our UV Developers here have over 25 years of Experience doing the stuff the do... I personally am not interested in learning the details of UV since nobody really uses this kinda stuff at Corporate Level.
I am simply surprised.... why UV is still used by a few Loyal Folk... when people with 25 years of experience simply cannot make it perform well. Joe > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Trevor Ockenden > Sent: Monday, March 29, 2004 9:17 PM > To: U2 Users Discussion List > Subject: Re: Modern Universe - was: The lists are closing > > 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users