MySQL order by rand() optimization

Optimize Order by RAND() in MySQL

Where when are dealing with large databases, and you want to query you database using ORDER BY RAND(), you will your query is very slow. This article shows you how to speed up this kind of queries.

http://akinas.com/pages/en/blog/mysql_random_row/

Your optimized ORDER BY RAND() queries will be hundreds time faster now.