[Bug 33303] New: Performance issues/timeouts when using more_subfields_xml in item search
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33303 Bug ID: 33303 Summary: Performance issues/timeouts when using more_subfields_xml in item search Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org When using items from more_subfields_xml in item search there are performance issues, especially on bigger data sets. more_subfields_xml is an XML blob type column in the items table, that will be used when you create additional item fields not mapped to another column in the items table. Not sure if something could be done here, but maybe there is something we could do to optimize processing? -- 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=33303 Katrin Fischer <katrin.fischer@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@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33303 mathieu saby <mathsabypro@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mathsabypro@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33303 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=33514 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org