Bug 18705

Summary: collections_tracking-table is missing index/foreign key to items
Product: Koha Reporter: Olli-Antti Kivilahti <olli-antti.kivilahti>
Component: CirculationAssignee: Andreas Jonsson <andreas.jonsson>
Status: Failed QA --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: andreas.jonsson, caroline.cyr-la-rose, gmcharlt, josef.moravec, kyle.m.hall, shi-yao.wang
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: Small patch Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 18705 - collections_tracking-table is missing index/foreign key to items
Bug 18705 - collections_tracking-table is missing index/foreign key to items
Bug 18705: collections_tracking itemnumber fk
Bug 18705: collections_tracking itemnumber fk

Description Olli-Antti Kivilahti 2017-05-31 08:54:48 UTC
This makes searches such as circ/pendingreserves.pl
rather slow and very noticeable on HDDs
Comment 1 Olli-Antti Kivilahti 2017-05-31 09:09:18 UTC
Created attachment 63859 [details] [review]
Bug 18705 - collections_tracking-table is missing index/foreign key to items

This makes searches such as circ/pendingreserves.pl
rather slow and very noticeable on HDDs
Comment 2 Olli-Antti Kivilahti 2017-05-31 09:35:28 UTC
Created attachment 63861 [details] [review]
Bug 18705 - collections_tracking-table is missing index/foreign key to items

This makes searches such as circ/pendingreserves.pl
rather slow and very noticeable on HDDs
Comment 3 Josef Moravec 2017-06-06 07:19:56 UTC
Please rebase
Comment 4 Katrin Fischer 2023-09-15 21:42:30 UTC
Still valid.
Comment 5 Andreas Jonsson 2024-09-04 11:00:18 UTC
Created attachment 171017 [details] [review]
Bug 18705: collections_tracking itemnumber fk

Add index an foreign key to the itemnumber in
the collections_tracking table for maintaining
database consistency and for scalability and
performance of
C4::RotatingCollections::isItemInAnyCollection
Comment 6 Shi Yao Wang 2024-09-26 19:31:54 UTC
Can we get a test plan?
https://wiki.koha-community.org/wiki/Commit_messages
Comment 7 Andreas Jonsson 2024-10-10 05:30:47 UTC
Created attachment 172579 [details] [review]
Bug 18705: collections_tracking itemnumber fk

Add index an foreign key to the itemnumber in
the collections_tracking table for maintaining
database consistency and for scalability and
performance of
C4::RotatingCollections::isItemInAnyCollection
Comment 8 Caroline Cyr La Rose 2025-03-31 14:52:34 UTC
Hi Olli-Antti,

There is still no test plan for this. Could you provide some information as to how this needs to be tested? Thanks!
Comment 9 Caroline Cyr La Rose 2025-03-31 14:53:43 UTC
Oops, sorry, I said Olli-Antti, but it seems Andreas has taken this bug :)