Bug 18705 - collections_tracking-table is missing index/foreign key to items
Summary: collections_tracking-table is missing index/foreign key to items
Status: Patch doesn't apply
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-31 08:54 UTC by Olli-Antti Kivilahti
Modified: 2023-09-15 21:42 UTC (History)
3 users (show)

See Also:
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 (1.90 KB, patch)
2017-05-31 09:09 UTC, Olli-Antti Kivilahti
Details | Diff | Splinter Review
Bug 18705 - collections_tracking-table is missing index/foreign key to items (1.92 KB, patch)
2017-05-31 09:35 UTC, Olli-Antti Kivilahti
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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.