Using mysql_unbuffered_query in Zend Frame Work, is it supported?

Question

I need to run a query that will receive a huge amount of records.
This means that I cannot use ZF wrappers for mysqli, which is under the hood, using mysqli-store-result. So, is there a ZF wrapper for using mysqli-use-result link text that will return Iterator / record-set / resource, and not an array with all the results already loaded into memory, or do I need to implement it myself?

Answer 1

First of all, no Zend Framework database adapters use ext / mysql . Adapters exist for ext / mysqli and ext / pdo_mysql .

In the MySQLi adapter, it always calls mysqli_store_result()(see Zend / Db / Statement / Mysqli.php, near line 250), which means that it only supports buffered query results. Zend Framework does not currently support any variation of this parameter, so you can try editing this line of code yourself to use mysqli_use_result().

edit: The PDO_MySQL adapter uses a buffered query by default .

PHP 5.4.6 source, ext / pdo_mysql / mysql_driver.c file, line 590, in the pdo_mysql_handle_factory () function:

H->buffered = H->emulate_prepare = 1;

, , fetchAll() , , , PHP. .