Originally Posted by Varius

Done right, you should always opt for doing it in mysql when you can as oppoed to in php.

For example, you might be pulling all your rows into an array and then picking out a random one in php....It's much more effective to use Mysql's function RAND instead in your actual query.