Hi, Is there a quicker way to get a selection of random rows than RAND()? I basically use:
SELECT * FROM table ORDER BY RAND() LIMIT 3; But I find that as the # of rows increases in table, it keeps taking longer and longer to get a result back. And I am talking a large increase, basically 50 rows took about 1 second, 700 rows now takes almost a minute. I am not sure why the # of rows would affect RAND. I am using the latest version of Mysql and php4 to get the rows. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php