cphalcon: Can not load more than 1000 items using Phalcon-3.0.x + PHP-7.0 + PostgreSQL

I can confirm this is working with Ubuntu 16.04 + nginx + PHP-5.6 + Phalcon-2.1.x + PostgreSQL-9.5

Yesterday, I decided to upgrade to PHP-7.0 + Phalcon-3.0.0 and found this code is not working anymore.

public static function findAllDetails($id) {
    $params = array('id' => $id,);
    $sql = "SELECT * FROM mytable WHERE id = :id";
    $item = new MyModel();  
    return new Resultset(null, $item, $item->getReadConnection()->query($sql, $params));
}

My result is more than 1000 items (actually ~ 4000 items), this code is working without any problem using Phalcon 2.1.x and showing in view as expected.

If the result got ~ 700 items, the code is working again.

No change in nginx.conf nor php.ini nor postgresql.conf in my installation.

Is this bug? Or I need to edit some “config” in my PHP-7.0 installation?

Ubuntu-16.04.1 LTS PHP 7.0.8-0ubuntu0.16.04.1 Phalcon-3.0.x latest build #a48bdbb PostgreSQL-9.5 nginx-1.10

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 29 (29 by maintainers)

Most upvoted comments

@Jurigag you’re right. Using zephir build for latest phalcon. Problem is solved

Thanks a lot

Were you trying what i posted many times - Adding getters and setters to models as well all properties to them ?