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