MySQL Forums
Forum List  »  PHP

Slow MySQL Queries
Posted by: Hassan Amin
Date: April 07, 2009 03:22PM

i have wallpaper site
i use this script for random wallpapers
but its make alot of slow mysql queries
please some one help me about this funtions
i use this
<?
$random="rand()";
$sql = "select SQL_NO_CACHE * from wallpaper where wallpaperid order by $random limit 10,5";
$result = mysql_query($sql, $db) or die(mysql_error());


please give some idea about rand() using in big database
thanks

Options: ReplyQuote


Subject
Written By
Posted
Slow MySQL Queries
April 07, 2009 03:22PM


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.