MySQL order by rand on large data sets

Posted about 1 year

More of a note to self than a real post. Great solution to extremely slow order by rand() queries when using large data sets by Paperplanes. Using this technique a query previously taking nearly 0.2 seconds was reduced to around 0.01 seconds.

Comments.

Say something!