MySQL Forums
Forum List  »  Newbie

Re: select limit records from 600000 records
Posted by: odelya glick
Date: October 31, 2009 02:30PM

hi

i need to select 10 random records from 400000.

the rand() consumed too much CPU.

since i didnt find a solution. i thought to select 10 records in a row.

is there a bettrt way for random select than that?

Options: ReplyQuote


Subject
Written By
Posted
Re: select limit records from 600000 records
October 31, 2009 02:30PM


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.