[Koha-bugs] [Bug 36239] Availability calculation in OPAC Results XSLT is too slow

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

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

--- Comment #2 from David Cook <dcook at prosentient.com.au> ---
(In reply to David Cook from comment #1)
> That said, when I actually break it down a bit more, it looks like out of 60
> seconds for my example, 20 seconds are availability and 40 seconds is the
> rest. If it's 10 seconds in the staff interface, then it's probably 30
> seconds on OpacHiddenItems which happens before buildKohaItemsNamespace. 
> 
> That's an overgeneralization of course. 
> 
> But if we got rid of OpacHiddenItemsHidesRecord and required people to use
> OpacSuppression instead then we'd be able to bring OPAC and Staff Interface
> back to similar times...

It looks like I was at least partially wrong... 

With no change, my search is actually taking 66 seconds, and if I completely
remove OpacHiddenItems, I only gain 11-12 seconds. 

In good news, I've written an optimization for OpacHiddenItems, which
effectively eliminates the overhead of running it. So yippee! I'll open a
different ticket for that.

But I was hoping to save more like 30 seconds. So it seems like there's still
more optimizing to do on other parts of OPAC search. It seems like there still
20 seconds unaccounted for in my search...

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