A generic server-side paging solution that could be applied to any SQL query we need would be a huge boon for the system. The query could be passed to a "pagify" subroutine, along with the starting and ending values, and the modified query returned. This would have the advantage of forcing sorts to apply BEFORE paging, so things like patron search results would be sorted globally, not just per page.
Is this resolved by using datatables and processing server side, like we do for the patrons now?
I think the move to DataTables using server-side processing resolves this one