Bug 6511 - Server-side paging of SQL queries
Summary: Server-side paging of SQL queries
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-16 18:06 UTC by Ian Walls
Modified: 2023-06-08 22:26 UTC (History)
1 user (show)

See Also:
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:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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