Re: SQLServer beats 8i finding top-10 duplicates

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 10 Jan 2000 22:02:01 -0000
Message-ID: <947542295.7754.0.nnrp-11.9e984b29@news.demon.co.uk>

Damn !

A technical term I don't understand.

Anyway I suspect you gave Oracle a
worst case scenario - I dropped my
sort_area_size to 4M, and retained to 3M and still got a pretty good result before going to disc - a much more reasonable
memory demand - and probably what
MS Server was doing anyway.

I used the dbms_random function 1,000,000 times to get my data (20 minutes CPU !). It certainly seemed to look nicely random.

Is LC the one where you keep multiplying a couple of big numbers and taking bits out of the middle ?

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <3879D379.3FE5_at_yahoo.com>...
>
>I used a linear congruential - I didn't check its period, but as with
>all LC generators, it would have cycled after some amount of time...
>
>A nice healthy sort_area_size = 16M certainly assisted in the timing
>results. I suppose you could call that cheating a little. :-)
>
Received on Mon Jan 10 2000 - 16:02:01 CST