[Koha-bugs] [Bug 16122] Item record needs to keep Local Use count

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

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

--- Comment #19 from Christopher Brannon <cbrannon at cdalibrary.org> ---
(In reply to Katrin Fischer from comment #18)
> (In reply to Christopher Brannon from comment #17)
> > (In reply to Lucas Gass from comment #14)
> > > I've added some patches that will add an items.localuse column to the items
> > > table and also display this in the holdings/other holdings table. 
> > > 
> > > Leaving as assigned as this will still need adjusted/updated tests. 
> > > 
> > > Not sure how to deal with the information that is already available via
> > > statistics. I really think we should leave the statistics table as is.
> > > However we may need a script or DB update that will make the new
> > > items.localuse column congruent with what can be derived from statistics.
> > 
> > I should clarify, it would be good to at least capture the existing stats
> > and convert them to the counters before those stats are eliminated through
> > table clean up.
> 
> https://stackoverflow.com/questions/1270944/mysql-innodb-not-releasing-disk-
> space-after-deleting-data-rows-from-table

Well, that is just insane.  REGARDLESS, I know for a fact that table queries on
smaller tables run faster.  Tables must be pruned on a regular basis to
maintain optimal performance.  This bug will ensure needed data is maintained
over time.

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