Category: PHP Scripts
-
Optimizing MySQL Rand() against Slowdowns
I was having having nightmares with mysql rand() function. Rand() function works well in pulling out rows randomly from the datbase and works well if you have a quite few hundred records. Ironically, it desperately slows down when you have a large table dataset above 10,000 rows. This is the traditional way of using mysql…