[Koha-bugs] [Bug 36033] Table pseudonymized_transactions needs more indexes

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

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

--- Comment #6 from Fridolin Somers <fridolin.somers at biblibre.com> ---
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.