mysql_li async 一步查询

最新推荐文章于 2021-11-17 15:40:12 发布

转载最新推荐文章于 2021-11-17 15:40:12 发布 · 1.1k 阅读

php 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一种使用 PHP 和 MySQL 进行异步查询的方法，通过实例展示了如何利用 mysqli 的异步特性来提高数据库查询效率。这种方法可以有效减少等待响应的时间，特别适用于需要频繁查询的高并发场景。

<?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;