We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Configuration

PDO Adapter and buffered query

I would like to be able to configure my pdo adapter to use buffered queries.

I've posted a detailed question on : https://stackoverflow.com/questions/22791011/phalconphp-how-do-i-switch-to-buffered-queries

Can anyone help me with this ?



39.4k

Andres offered a solution:

return new \Phalcon\Db\Adapter\Pdo\MySql(array(
    "host"     => $options["host"],
    "username" => $options["username"],
    "password" => $options["password"],
    "dbname"   => $options["dbname"],
    "options"  => array(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true)
));

You can pass any PDO options in your adapter's constructor array :)