[Koha-bugs] [Bug 22440] Improve ILL page performance by moving to server side filtering

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

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

--- Comment #25 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Tomás Cohen Arazi from comment #24)
> (In reply to Katrin Fischer from comment #23)
> > (In reply to Katrin Fischer from comment #22)
> > > (In reply to Katrin Fischer from comment #19)
> > > > Hm, I am not so happy about the FK change hidden/sneaked in with this bug.
> > > > Especially since it's now without documentation/warning to users and can
> > > > create data loss. 
> > > > 
> > > > If you don't store all information also in ILL request attributes it will be
> > > > hard to determine what has been ordered for making acq decisions and
> > > > creating reports.
> > > > 
> > > > Also: there already was as specific bug for this change, stuck in discussion
> > > > for these reasons: bug 21983
> > > 
> > > I'd have loved to at least get a comment/reaction. The fix mentioned seems
> > > to be to enforce the change I marked as critical.
> > 
> > Also, if you really want to do this, because it needs to be done: what's
> > with the old ill_requests? It caused bug 33873.
> 
> Should we do the same we did for orderlines?

A database table has the option to use COALESCE, so that might be an option. We
could also then shift the existing data.

I am not sure what the technical requirement for the FK was, so can't tell if
removing it again might be a valid option.

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