[Koha-bugs] [Bug 22690] Merging records with many items too slow (Elasticsearch)

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

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

--- Comment #201 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
I sent the following email to Chris yesterday:

"""
A couple of questions:
  * Having the FK means the ON UPDATE SET NULL clause will apply. We
will "lose" the links but as the ids can be reused several times I
think it makes sense.
  * We will need to update existing entries (set to NULL when 0 or
deleted), we can take the opportunity to remove the rows with
biblionumber=null, itemnumber=null, biblionumber=null.
"""

his reply:
"""
The table is mainly just report the usage of electronic resources. So
if the resource is deleted it doesn't make sense to keep how many
times it whats viewed, so I think the FK will be fine
"""

Maybe we should then have a delete cascade on the biblionumber.

Please help here, I am not willing to follow-up myself.

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