Bug 18705

Summary: collections_tracking-table is missing index/foreign key to items
Product: Koha Reporter: Olli-Antti Kivilahti <olli-antti.kivilahti>
Component: CirculationAssignee: Bugs List <koha-bugs>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: andreas.jonsson, gmcharlt, josef.moravec, kyle.m.hall, shi-yao.wang
Version: Main   
Hardware: All   
OS: All   
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