https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38181
Bug ID: 38181
Summary: Extreme slow search results on OPAC (only) search when
result records contain multiple items.
Change sponsored?: ---
Product: Koha
Version: 24.05
Hardware: All
OS: Linux
Status: NEW
Severity: normal
Priority: P5 - low
Component: Searching
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
When performing a search on the OPAC, if the results containing records that
are having a large number of holdings (e.g serials with over 1000 issues/items
or even less) there is a huge delay on showing the results (~x8 times slower
for the same search if we remove the multiple items from the resulting records)
The odd is that the exact same search on the intranet interface works without
these delays so I'm guessing that this is a problem on the OPAC search
implementation?
The problem exists with zebra but also with the use of Elasticsearch engine.
Using elasticsearch tried also removing all the item related indexes - 952*
subfields (and re-indexing) but the result is the same.
In the following google drive link you can find a demo bib record with 1809
items (MarcXML - Marc21) if it helps to reproduce
it.https://drive.google.com/file/d/11SQmfdWal9tzcovS0mrgu6vIOPf1aCbc/view
You will have to import the record, and then try searching for the title on
OPAC: The Journal of biological chemistry.
In my case with a decent server without load (Debian, 4cpu cores, 16gb RAM)
with plack enabled takes about ~50sec to get the result.
Regards
--
You are receiving this mail because:
You are the assignee for the bug.
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/
