https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122
--- Comment #19 from Christopher Brannon <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
