[Koha-bugs] [Bug 16855] Poor performance due to high overhead of SQL call in export.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jul 6 17:36:06 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16855
Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jonathan.druart at bugs.koha-c
| |ommunity.org
--- Comment #4 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Quick benchmark using:
use Koha::Biblioitems;
my @record_ids;
my $biblioitems = Koha::Biblioitems->search( {}, { join => 'items', columns =>
'biblionumber' } );
while ( my $biblioitem = $biblioitems->next ) {
push @record_ids, $biblioitem->biblionumber;
}
and
use Koha::Biblioitems;
my @record_ids;
my $biblioitems = Koha::Biblioitems->search( {}, { join => 'items' } );
while ( my $biblioitem = $biblioitems->next ) {
push @record_ids, $biblioitem->biblionumber;
}
gives 1.4s vs 1.7s with 8600 items.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list