Optimizing MySQL Rand() Function
115
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.Hits |
Posted on: 2008-01-07 13:28:54 by admin
Website: corpocrat.com
Category:
Tags: mysql rand function slow
Visit Site
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