[Koha-patches] [PATCH] Bug 4470 Patron search result pagination bar
Frédéric Demians
f.demians at tamil.fr
Sat May 8 08:27:51 CEST 2010
Obviously, Koha global pagination function could be improved. This patch
do something which belongs to this function. A CPAN module like
Data::Page could help or be an inspiration... 3.4?
There is also room for improvement in they way resultset are
constructed. The whole set is retrieved and just a subset is displayed.
It impacts performances for libraries with a great number of patrons.
The right solution would be:
- to find the resultset size with SELECT COUNT(*)
- to retrieved the exact subset with LIMIT and OFFSET SQL arguments
---
members/member.pl | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/members/member.pl b/members/member.pl
index 58485b6..e92ab43 100755
--- a/members/member.pl
+++ b/members/member.pl
@@ -147,7 +147,8 @@ $template->param( letters => \@letters );
$template->param(
paginationbar => pagination_bar(
- $base_url, int( $count / $resultsperpage ) + 1,
+ $base_url,
+ int( $count / $resultsperpage ) + ($count % $resultsperpage ? 1 : 0),
$startfrom, 'startfrom'
),
startfrom => $startfrom,
--
1.7.1
More information about the Koha-patches
mailing list