https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38130
--- Comment #19 from Jonathan Druart <[email protected]> --- To summary PM between Pedro and me. We should not use library's name to compare with and without the patch, we should compare with the same number of results returned (ofc!) Tested with the following script: use t::lib::TestBuilder; my $builder = t::lib::TestBuilder->new; my @branchcodes = Koha::Libraries->search->get_column('branchcode'); my $biblio = $builder->build_sample_biblio; for my $i ( 1..1000 ) { say $i; my $branchcode = @branchcodes[int(rand(scalar @branchcodes))]; $builder->build_sample_item({biblionumber => $biblio->biblionumber, library => $branchcode }); } say "biblionumber=".$biblio->biblionumber; Search "2024" in the global search to make sure 20 items will be displayed and the JOIN will happen. No need to use the column filters. I confirm the previous numbers ~700ms without vs ~900ms with those 2 patches. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
