Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Paginator memory leak?

Hey guys!

// Passing a resultset as data
$paginator = new PaginatorModel(
        'data'  => Products::find(),
        'limit' => 10,
        'page'  => $currentPage,

What's the point in this option, if the records are 1 million? They will all be remembered. Or not? Tell me how to do data pagination in which large volumes.


"Use a Phalcon\Mvc\Model\Resultset object as source data. Since PDO doesn’t support scrollable cursors this adapter shouldn’t be used to paginate a large number of records"

I'm pretty much always using the QueryBuilder to create my queries.