<?php
/**
* php_msyql 异步查询
* @reference http://www.walu.cc/php/async-mysql-query.md
* @author zhenghua
* @date 2015/6/8
**/
$host = '127.0.0.1';
$user = 'root';
$password = '';
$database = 'dbtest';
$result = array(1=>0, 2=>0, 3=>0);
$time_start = microtime(true);
$links = array();
foreach ($result as $key => $value) {
$obj = new mysqli($host, $user, $password, $database);
$links[spl_object_hash($obj)] = array('value'=>$key, 'link'=>$obj);
}
$done = 0;
$total = count($links);
foreach ($links as $key => $value) {
$value['link']->query("SELECT COUNT(*) AS `total` FROM `demo` WHERE `value`={$value['value']}", MYSQLI_ASYNC);
}
do{
$tmp = array();
foreach ($links as $value) {
$tmp[] = $value['link'];
}
$read = $errors = $reject = $tmp;
$re = mysqli_poll($read, $errors, $reject, 1);
if (false === $re) {
die('mysqli_poll failed');
} elseif ($re < 1) {
print_r($done);
continue;
}
foreach ($read as $link) {
print_r($done);
$sql_result = $link->reap_async_query();
if (is_object($sql_result)) {
$sql_result_array = $sql_result->fetch_array(MYSQLI_ASSOC);//只有一行
$sql_result->free();
$hash = spl_object_hash($link);
$key_in_result = $links[$hash]['value'];
$result[$key_in_result] = $sql_result_array['total'];
} else {
echo $link->error, "\n";
}
$done++;
}
foreach ($errors as $link) {
echo $link->error, "1\n";
$done++;
}
// foreach ($reject as $link) {
// printf('server is busy, client was projected.\n',$link->connect_error,$link->error);
// }
} while($done < $total);
var_dump($result);
echo 'ASYNC_QUERY_TIME:'.(microtime(true)-$time_start),PHP_EOL;;
$link = end($links);
$link = $link['link'];
echo PHP_EOL;
//平常顺序时间
$time_start = microtime(true);
$reuslt = array(1=>0, 2=>0, 3=>0);
foreach ($result as $key => $value) {
$sql_result = $link->query("SELECT COUNT(*) AS `total` FROM demo WHERE `value`={$key}");
if(is_object($sql_result)){
$sql_result_array = $sql_result->fetch_array(MYSQLI_ASSOC);
$sql_result->free();
$result[$key] = $sql_result_array['total'];
} else {
echo PHP_EOL;
}
}
var_dump($reuslt);
echo "COMM_QUERY_TIME:",microtime(true)-$time_start,PHP_EOL;