dimanche 28 juin 2015

Mysql "where rand()" perfomance

I'm trying to pick random articles from my database, where high rating articles have a higher chance of getting picked

SELECT * FROM articles WHERE RAND()>0.1  ORDER BY rating  DESC LIMIT 3

My question is: Will it random the whole table, or just until it finds 3 articles that random a number higher then 0.1




Aucun commentaire:

Enregistrer un commentaire