2007. 02. 20, kedd keltezéssel 01.33-kor Fergus Gibson ezt írta:
> How about this instead, Mike?
>
> <?php
> // some code
>
> $fortune = mysql_query("SELECT text FROM fortunes ORDER BY RAND() LIMIT 1");
> $fortune = mysql_fetch_row($fortune);
> $fortune = sprintf(
> '<span class="quotecyc">"%s"<br />-Omniversalism.com</span>',
> $fortune[0]
> );
>
> // some more code
> ?>
>
> MySQL is implemented in random code, so it can probably perform this
> operation faster, and this code is much cleaner. You may want to move
> away from mysql since it's essentially deprecated. I have switched to
> mysqli and prefer it.
>
a week ago or something like that there was an extensive discussion here
about ORDER BY RAND being slow and inefficient on large tables
read this:
http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/
greets
Zoltán Németh
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
