David Yes, there are many threads that have bored me silly but I just delete them.
I suspect if Joe perseveres here we may actually assist him by speeding up his UV application. Also, other "quiet" bystanders (like myself at times) pick up valuable pieces of information from observing these threads. That is the real pity of it as this opportunity is about to cease. Thanks again to Clif for making it available for so long. Cheers Trevor Ockenden OSP ----- Original Message ----- From: "Hona, David S" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 12:15 PM Subject: RE: Modern Universe - was: The lists are closing > > Is it just me or this getting really BORING! (and that's be REALLY nice > about it) > > LOL. > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Joe Eugene > Sent: Tuesday, March 30, 2004 12:07 PM > To: U2 Users Discussion List > 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 > -- > 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
