Bug 6511

Summary: Server-side paging of SQL queries
Product: Koha Reporter: Ian Walls <koha.sekjal>
Component: Architecture, internals, and plumbingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED WONTFIX QA Contact: Bugs List <koha-bugs>
Severity: enhancement    
Priority: P5 - low CC: dcook
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Ian Walls 2011-06-16 18:06:41 UTC
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.
Comment 1 Katrin Fischer 2014-11-02 08:49:38 UTC
Is this resolved by using datatables and processing server side, like we do for the patrons now?
Comment 2 David Cook 2022-08-22 00:57:49 UTC
I think the move to DataTables using server-side processing resolves this one