https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36033
--- Comment #6 from Fridolin Somers <[email protected]> --- Table "pseudonymized_transactions" is dedicated to be used in SQL reports. There is a good chance "transaction_type" will be used to count checkouts, checkins ... The "itemnumber" can be used for a join with items table. This will be much more performant with an index. Some item datas are in pseudonymized_transactions (for when item is deleted). But for catalogs that mostly do not delete there items they may want to join for more datas. Also can be used to count patron checkouts on same item. See that table "statistics" as indexes : KEY `type_idx` (`type`), KEY `itemnumber_idx` (`itemnumber`), I agree we need to balance query performance with row creating speed. So we may not add indexes on all columns. -- 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/
