I was overestimating the blow of database's network transfer of a huge array with results back to PHP. Not a big deal, if done right, at least on 100k of pages. Query (from my post earlier today) is perfectly indexed. I can foresee some slowdown on 1m of records, but at that point
more knowledge can be invested in extending the SQL to avoid the data transfer to client. I am not that
knowledgeable, unfortunately (but if you follow, I am working on it
It was worth a trial to actually send results to PHP and see the impact. Average query result is within 0.20 sec. - uploaded the video here https://send.firefox.com/download/c7a1a ... Cd9YeIxf1A
To recap, the navigation respects
settings from <cms:config_list_view /> (if present) and actually scans through all pages without hard limit, position is the same as in backend. Thanks for attention (if any)
P.S. It would be amazing to support custom editables for orderby and dynamic order when we click on column's header in backend and reorder pages. However, I am totally satisfied with current code. If anyone needs custom orderby, contact me any time.