We tried to execute the
Model::find() method on a mysql dataset with over a million entries and got an memory overflow before iterating over the
Resultset. The overflow does not happen, when querying the same table with
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY = false, we didn't get an overflow, but the
Resultset was empty.
$phalconDb = new \Phalcon\Db\Adapter\Pdo\Mysql(...); $result = $phalconDb->query("SELECT * FROM schinkens"); while($schinken = $result->fetch()) print_r($schinken);
Any ideas what the problem is? What do we need to consider when handling huge tables like this?
Thanks for your help!