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.
My question is does using the query builder help when retreving a large number of records (Say a few thousand).
Will using the query build adapter prevent a full table scan?
I'm sorry if this is garbled thinking and goes unanswered but besides the abilty to form your own query my mind is screaming why.