[Koha-bugs] [Bug 33303] Performance issues/timeouts in item search

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33303

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Performance issues/timeouts |Performance issues/timeouts
                   |when using                  |in item search
                   |more_subfields_xml in item  |
                   |search                      |

--- Comment #1 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
It looks like there is a general issue with item search being very slow in some
cases. One issue is left truncation of search terms.

The example is an ISBN search. Multiple ISBN are stored in biblioitems.isbn |
separated with additional ISBD punctuation. So you'll need to truncate left and
right to make sure you get correct results.

Left truncation creates an issue as we assume the index on the field cannot be
used in this case.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.