Re: performance of ORDER BY random()

On Fri, Mar 23, 2001 at 02:09:57PM -0800, culley harrelson wrote:
> Does anyone have any input on the performance of ORDER BY random() ? I
> have been developing using this feature and it would be good to know
> what to expect when my tables increase in size :)

noe thing to try would be to create a tinker-toy database and
populate it with a few hundred thousand records. then see what
you get when you

...order by random()...

then /you/ can tell /us/ what the results are.

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!