Thread: performance of ORDER BY random()

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 :)

Culley

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@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!