https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40741 Bug ID: 40741 Summary: OPAC searches for records with many items are very slow Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org I tested in k-t-d, with default data. I brought my k-t-d up with the es7 option. When you have a results page with multiple records having many items on it searches become too slow on the OPAC: On the staff interface: 1 records w/ 1000 items: 1300ms 2 records w/ 1000 items: 1701ms 3 records w/ 1000 items: 2023ms 4 records w/ 1000 items: 2344ms 5 records w/ 1000 items: 2700ms 6 records w/ 1000 items: 2909ms 7 records w/ 1000 items: 3217ms 8 records w/ 1000 items: 3625ms These are all pretty reasonable given the large number of items. OPAC: 0 records w/ 1000 items: 2102ms 1 records w/ 1000 items: 12415ms 2 records w/ 1000 items: 23250ms 3 records w/ 1000 items: 34216ms I stopped at 3 because 34216 is already too slow. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.