We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Developer Tools

Devtools, Scaffold, and Pagination on large table

I am using the sample employee database at https://github.com/datacharmer/test_db

There are 300,024 records in the employees table

I created a project and scaffolding with devtools.

However on the search, if you leave all the fields blank it returns "1/30003" but I noticed the Memory use shoots through the roof even tho it is only returning 10 rows to the screen.

This page was created in 0.4265570640564 seconds 88 mb

It doesn't seem to account that it might be grabbing quite a few rows.



77.7k

Watch out with paging, array and model adapters will fetch all records and THEN limit them. If you have many records, always use the query builder adapter!

https://docs.phalcon.io/en/3.0.0/reference/pagination.html#data-adapters



478