3 ms·

Try running EXPLAIN on that query. It has to create a temporary table, add a random column for every row, and then sort on that column. Not very fast.

• broshnat 14y ago
  Ok, how about get the max ID and run a loop of 10 queries matching a random ID between 1 and maxID?
  • eurleif 14y ago
    That's essentially what the top-voted answer does, except it accounts for gaps in the IDs.