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.



66.0k
Accepted
answer

https://olddocs.phalconphp.com/en/3.0.0/reference/pagination.html

"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.