mysql rand function slow >>
96
Hits
Hits
Optimizing MySQL Rand() Function
MySQL Rand() function works well in pulling out rows randomly from the database. It only works well if you have a quite few hundred records. Ironically, it slows down the server when you have a large table dataset above 10,000 rows. Instead of making mysql generate random, you generate a random value with php and then pull that random value from the table.Posted by: admin | Tags: mysql rand function slow | URL: corpocrat.com | visit
Search Tag Cloud
• mysql rand function slow • mysql rand slow • connect mysql php • optimize mysql php • php paging mysql • mysql code generator • mysql query optimization • store images mysql