[Koha-bugs] [Bug 6511] New: Server-side paging of SQL queries

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6511

             Bug #: 6511
           Summary: Server-side paging of SQL queries
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Architecture, internals, and plumbing
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: ian.walls at bywatersolutions.com
         QAContact: koha-bugs at lists.koha-community.org


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.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.