> 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/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
