| shuffle data retrieved from database |
[eluser]CroNiX[/eluser]
Heres a good article explaining how order by rand can eat memory with large tables and a great workaround (order by rand creates a temp table of all results first...which might not be good) http://www.paperplanes.de/2008/4/24/mysql_nonos_order_by_rand.html |
| Messages In This Thread |
|
shuffle data retrieved from database - by El Forum - 10-20-2010, 11:17 AM
shuffle data retrieved from database - by El Forum - 10-20-2010, 11:37 AM
shuffle data retrieved from database - by El Forum - 10-20-2010, 11:46 AM
shuffle data retrieved from database - by El Forum - 10-20-2010, 01:35 PM
shuffle data retrieved from database - by El Forum - 10-20-2010, 01:49 PM
|
