Re: Quick SQL Question
| From: | Greg Donald | Date: | Wed, 18 Jun 2003 01:22:20 +0000 |
| Subject: | Re: Quick SQL Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-151922@lists.php.net to get a copy of this message | ||
> I'm using the "ORDER BY RAND() LIMIT 0,1" to give be a random record from a
> recordset but it seems like it puts a real heavy load on the server. Is
> there a better way to pull a random record from a database?
I used order by rand() with MySQL quite often and do not notice any load issues
with it. What's your whole query look like?
--
Greg Donald
http://destiney.com/