We are moving our forum in GitHub Discussions. For questions about Phalcon v3/v4 you can visit here and for Phalcon v5 here.

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 : http://stackoverflow.com/questions/22791011/phalconphp-how-do-i-switch-to-buffered-queries

Can anyone help me with this ?

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 :)