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
