From a44bb07b88ba9d5049a64f88610a8bb8e82efe3a Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Tue, 5 Jul 2016 14:49:35 -0400 Subject: [PATCH] Bug 16855 - Poor performance due to high overhead of SQL call in export.pl This patch eliminates all columns retrieved in the biblioitems query except for biblionumber. To test: 1 - Go to tools->Export data 2 - Export using various filters and note you get expected records 3 - Apply patch 4 - Ensure exported results match results before patch Signed-off-by: Srdjan Signed-off-by: Kyle M Hall --- tools/export.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tools/export.pl b/tools/export.pl index 4794d05dfc..373ebfa0a4 100755 --- a/tools/export.pl +++ b/tools/export.pl @@ -148,7 +148,7 @@ if ( $op eq "export" ) { ), }; - my $biblioitems = Koha::Biblioitems->search( $conditions, { join => 'items' } ); + my $biblioitems = Koha::Biblioitems->search( $conditions, { join => 'items', columns => 'biblionumber' } ); while ( my $biblioitem = $biblioitems->next ) { push @record_ids, $biblioitem->biblionumber; } -- 2.39.5