Re: MySQL rand() is slow on large datasets

[Jay Paroline]

The way to make that fast:

SELECT * FROM Table T JOIN (SELECT FLOOR(MAX(ID)*RAND()) AS ID FROM Table) AS x ON T.ID >= x.ID LIMIT 1;

It's not pretty but it is fast. The way Thomas suggested causes the MAX()*RAND() to be executed for every row comparison.