How to use async Mysql query with PHP PDO

Question

The Mysqlnd driver PHP 5.6 have opportunity to use a Async queries http://php.net/manual/en/mysqli.reap-async-query.php

How to use Async queries with PDO?

it is not work, code (PHP asynchronous mysql-query):

$dbConnectionOne = new \PDO($cnn0, $conf['user'], $conf['pass']);
$dbConnectionOne->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);

$dbConnectionTwo =  new \PDO($cnn0, $conf['user'], $conf['pass']);
$dbConnectionTwo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$dbConnectionTwo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);


$t = time();
$synchStmt = $dbConnectionOne->prepare('SELECT sleep(2)');
$synchStmt->execute();

$asynchStmt = $dbConnectionTwo->prepare('SELECT sleep(1)');
$asynchStmt->execute();

$measurementConfiguration = array();
foreach ($synchStmt->fetchAll() as $synchStmtRow) {
   print_r($synchStmtRow);
}

while (($asynchStmtRow = $asynchStmt->fetch()) !== false) {
   print_r($asynchStmtRow);
}


$t = time() - $t;

echo 'query execute ', $t, ' sec',PHP_EOL;

excepted 2 sec but result = 3 sec

Look at this: http://stackoverflow.com/questions/27240421/php-asynchronous-mysql-query — Tom, Feb 15 '16 at 12:51

score 7 · Accepted Answer · answered Feb 15 '16 at 12:56

7

No. You cannot use Mysql async queries with PDO. Mysqli is the only choice.

You can use for this either mysqli_multi_query or the regular query/poll/reap sequence.

answered Feb 15 '16 at 12:56

Your Common Sense

156,878
40
214
345

Thanks, I have my wrapper class on PDO and find way of use async in PDO. – Alexandre Kalendarev Feb 15 '16 at 13:26
Thx for sharing, but no. – EthraZa Dec 13 '16 at 15:45

How to use async Mysql query with PHP PDO

1 Answers1

Linked