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: stackoverflow.com/questions/27240421/…

Tom
– Tom

2016-02-15 12:51:32 +00:00
Commented Feb 15, 2016 at 12:51 — Tom
– Tom, Commented Feb 15, 2016 at 12:51
it is not work, code

Alexandre Kalendarev
– Alexandre Kalendarev

2016-02-15 13:18:43 +00:00
Commented Feb 15, 2016 at 13:18 — Alexandre Kalendarev
– Alexandre Kalendarev, Commented Feb 15, 2016 at 13:18

Your Common Sense · Accepted Answer · 2016-02-15 12:56:39Z

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, 2016 at 12:56

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alexandre Kalendarev Over a year ago

Thanks, I have my wrapper class on PDO and find way of use async in PDO.

EthraZa Over a year ago

Thx for sharing, but no.

Collectives™ on Stack Overflow

How to use async Mysql query with PHP PDO

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related