MySQL Forums :: PHP :: Slow MySQL Queries


Advanced Search

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 Hassan Amin 04/07/2009 03:22PM
Re: Slow MySQL Queries Kristian Köhntopp 04/08/2009 05:59AM


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.