We hear: Order by Rand() is bad for large tables. But how many rows is large?
- by ggg
I use order by rand() LIMIT 1. I have a database with 150,000 rows and I'm getting split second results after a select of three tables. If I stay under a million rows, am I going to be OK?
At what point should I consider upgrading my code to something more sophisticated?