[Koha-bugs] [Bug 31856] Improve performance of serials subscriptions search

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

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

--- Comment #16 from David Gustafsson <glasklas at gmail.com> ---
(In reply to Jonathan Druart from comment #12)
> (In reply to Jonathan Druart from comment #11)
> > Is the change in SearchSubscriptions really makes things faster?
> 
> Right, there is no FK. Maybe we are just missing an index on a DB column
> then?

I tried adding an index for that column and did not make much of a difference,
perhaps a few percent at most if even that. 99% of the cost is DBIx, the
database query itself is a neglectable part if using and index or not.

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