[Bug 28922] New: Vendor search has poor performance when system has many vendors
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Bug ID: 28922 Summary: Vendor search has poor performance when system has many vendors Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org In acquisitions our search does a 'contains' search on vendor name We then loop through the vendors and lookup the baskets We then lookup the groups for each basket we found It would be nice if we could fetch all the info needed in one call to the DB and possibly add paging -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |tomascohen@gmail.com |ity.org | CC| |joy@bywatersolutions.com, | |kyle@bywatersolutions.com, | |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com --- Comment #1 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- How many is many? 100, 1000, 10000? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 --- Comment #2 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Jonathan Druart from comment #1)
How many is many? 100, 1000, 10000?
Depends on the hardware. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 --- Comment #3 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- (In reply to Kyle M Hall from comment #2)
(In reply to Jonathan Druart from comment #1)
How many is many? 100, 1000, 10000?
Depends on the hardware.
Lol yes, I know, but it's good to have an idea to recreate the problem locally. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=13371 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy@rijksmuseum.nl --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- *** Bug 11215 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 --- Comment #5 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Jonathan Druart from comment #3)
(In reply to Kyle M Hall from comment #2)
(In reply to Jonathan Druart from comment #1)
How many is many? 100, 1000, 10000?
Depends on the hardware.
Lol yes, I know, but it's good to have an idea to recreate the problem locally.
This will do it: #!/usr/bin/perl use t::lib::TestBuilder; my $builder = t::lib::TestBuilder->new; for ( my $i = 0; $i < 100; $i++ ) { my $b = $builder->build({ source => 'Aqbookseller' }); for ( my $i = 0; $i < 100; $i++ ) { my $basket = $builder->build({ source => 'Aqbasket', value => { booksellerid => $b->{id} } }); } } -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28922 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=12762 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org