Baidu consulted some of the information, combined with some of their own experience, the following solutions:
Copy CodeThe code is as follows:
$idlist = ";
for ($i =1; $i <=20; $i + +) {
if ($i ==1) {
$idlist =mt_rand (3,25216);
}
else{
$idlist = $idlist. ', '. Mt_rand (3,25216);
}
}
$query = "SELECT * from table where ID in ($idlist) LIMIT 0,10";
The principle is actually very simple, is to produce a set of random ID, and then retrieve the set of IDs corresponding records, after such optimization, the page open speed significantly faster, CPU occupancy rate is almost 0, hehe ~ the way to use this idea of SQL Server site also optimized a bit!
Speed comparison:
Use Rand () to take 10 random records to 400 milliseconds, and the above method as long as 0.6 milliseconds, the difference is too big!!!
http://www.bkjia.com/PHPjc/321896.html www.bkjia.com true http://www.bkjia.com/PHPjc/321896.html techarticle Baidu consulted some of the information, combined with some of its own experience, the following solutions: Copy code code as follows: $idlist = "; for ($i =1; $i =20; $i + +) {if ($i ==1) {$idlist =mt_rand (3,...