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: Patch doesn't apply --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt, josef.moravec, kyle.m.hall
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
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

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.