[Koha-bugs] [Bug 18441] New: add primary, foreign keys to statistics table
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Apr 18 01:18:14 CEST 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18441
Bug ID: 18441
Summary: add primary, foreign keys to statistics table
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Circulation
Assignee: koha-bugs at lists.koha-community.org
Reporter: barton at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com
I think that the primary key would be useful for Bug 9717 'localuse recorded
for holds/transfers' -- we could record 'localuse' when the item is checked in,
and then update the statistics record to 'holdcaptured' or 'transferred' if the
check-in captures a hold or completes a branch transfer.
The statistics table is *very* slow to join borrowers or items against, because
borrowernumber and itemnumber are not indexed. It also caused a 12 hour run of
updatedatabase on site that had a large statistics table, when running the
upgrade that fixed bug 14598 (itemtype is not set on statistics by
C4::Circulation::AddReturn). This occurred on the 16.06.00.039 update.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list