You must be Missing the Thread Completely. Just like you started another One here.... What do you want?
You Don't want me to reply to Direct Questions? "You seem to have some other issues." If something is NOT right...I will come out LOUD and Say it on any Forum. I am NOT a ***Disciple*** of any Technology... What Works well is the Best Tool. Yes, i am saying UV does NOT Perform/Scale Well with LARGE Amounts of Data. If you Dont Agree, Prove it... Everybody can Talk.. Where are your Test Results? Joe Eugene >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of Logan, David (SST - Adelaide) >Sent: Monday, April 05, 2004 7:42 PM >To: U2 Users Discussion List >Subject: RE: Modern Universe (TESTING) > > >Hi Joe, > >I must admit to being completely baffled as to your point. Are you > >1) Trying to prove you know something about MS SQL? >2) Trying to prove you know something about Oracle? >3) Trying to prove you know nothing about Universe? >4) Trying to prove you haven't been to any course on the presentation of >test results? >5) Trying to prove you are stubborn and not willing to listen to others >who may know better? >6) Trying to prove you are willing to show how you can compare apples >with pears? >7) Trying to prove to others who know otherwise that UV doesn't work and >not succeeding? >8) Trying to prove you can become irrational and angry when people >question your work? > >I think you have succeeded in all of the above objectives admirably. >Congratulations on a fine job 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, 6 April 2004 8:40 AM >To: U2 Users Discussion List >Subject: RE: Modern Universe (TESTING) > > >Will, > >> Joe I think Zero is an exagerration. > >This is NOT an Exaggeration, these are TEST Results from well maintained >SQL Tables. > >SQL: >select count(*) from TableName >Or >select count(@IdentityField) from TableName (This is Faster than the >above) > >The above 2 ran against MS-SQLServer instant. > >Here is the code, if you would like to test. >declare @stime dateTime; >set @stime = getDate(); >select count(*) from CustomerMaster >print dateDiff("ms",@stime,getDate()) > >Joe Eugene > > > > > >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On >> Behalf Of [EMAIL PROTECTED] >> Sent: Monday, April 05, 2004 1:16 PM >> To: U2 Users Discussion List >> Subject: Re: Modern Universe (TESTING) >> >> In a message dated 4/4/2004 11:28:33 PM Eastern Standard Time, >> [EMAIL PROTECTED] writes: >> >> > The other day.. i was inspecting a UV File with a UV Developer, he >ran a >> > "COUNT FILENAME" >> > on our Customer Master... (BTW Quad CPU 4GHZ)... It took 12-15 >Minutes >> to >> > get a result >> > back from UV. The file only had 800,000 Records. >> > >> > This kind of Operation normally takes "ZERO" Milliseconds >> > in any Enterprise >> > RDBMS. >> > >> > I had nothing to say but LAUGH!. >> > >> > Joe Eugene >> >> Joe I think Zero is an exagerration. >> However, if this file had an INDEX on it, you could get a "COUNT" by >> merely doing a >> LIST-INDEX filename indexname someoptions >> One of the output is the number of items indexed for each index entry, >the >> total is identical to the number of records in the file. >> Will >> -- >> 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
