MySQL Forums
Forum List  »  Performance

MySQL rand() is slow on large datasets
Posted by: pbu pbu
Date: July 24, 2007 08:19AM

I love mysql because of its ease and performance wide. But when it comes to rand() on large datasets (with more than 100k rows) the query dramatically slows down the server and performance is way too bad.

Are mysql engineers doing something about this? Is there any good workaround? I am using mysql with php and thinking of pulling about 10 rows randomly from the table.

Thanks :)



Edited 1 time(s). Last edit at 07/24/2007 08:19AM by pbu pbu.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL rand() is slow on large datasets
18003
July 24, 2007 08:19AM
7269
September 02, 2007 10:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.