Hey guys. I'm buiding my first web app with phalcon (and in general) and I have a confusion on how to arrange pagination for not very small (~20000 rows >20 columns) database. I've tried both Model and Query builder adapters, seems like Query builder is significantly faster.
However I can't use resultSet directly from Query builder pagination e.g. to show all row details on click (if I load only few columns for pagination) or to sort results without exec additional query. Is it correct?
I have plan B to use cached result set with Model pagination adapter. Is it good practice?
What is the best way(if there is) to use cache In case of a) Model b)Query builder adapter?