Re:Things in MySQL that won't work as expected
by axiak on Sunday November 07, 2010 @09:41PM
(#1881160)
haven't we learned that order by rand() is a bad idea?
[ Parent
| on HN ]
Re:Things in MySQL that won't work as expected
by compay on Sunday November 07, 2010 @10:06PM
(#1881216)
That depends on how and when you're going to use it. It's fine with small data sets, or if you're going to run the query and cache its output periodically. With MySQL you can also speed it up quite a bit by selecting only an indexed column rather than `SELECT *`.
But yeah, if it's in a query that you're going to run on every single hit to the index page of a busy site, then you're going to have problems.