Phalcon $paginator->getPaginate() for all page
SELECT COUNT(*) AS
rowcount FROM ..;
I suggest only do the estimantion once (or none at all - just lazy loading and indicate if there is more pages) and save in session.
Thanks a lot.
BTW, I love Phalcon and wish it be perfect.