[Koha-bugs] [Bug 36261] New: Calculating OpacHiddenItems is too slow in OPAC search

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

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

            Bug ID: 36261
           Summary: Calculating OpacHiddenItems is too slow in OPAC search
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org

Calculating items and records hidden by OpacHiddenItems it slow. Too slow.

Fortunately, I've come up with an optimization which seems to effectively
eliminate the overhead added by OpacHiddenItems.

Basically, instead of running 1 query per item, I run 1 query per bib to get
all hidden items. It's pretty straightforward, but I'd like to battle-test it a
bit more. I'm also writing this optimization for an older version of Koha, and
I still have more optimizing I want to do, so I'm not going to post my patch
just yet...

It's coming though!

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