Bug 18705 - collections_tracking-table is missing index/foreign key to items
Summary: collections_tracking-table is missing index/foreign key to items
Status: Needs Signoff
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-31 08:54 UTC by Olli-Antti Kivilahti
Modified: 2024-10-10 05:30 UTC (History)
5 users (show)

See Also:
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 (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
Bug 18705: collections_tracking itemnumber fk (2.77 KB, patch)
2024-09-04 11:00 UTC, Andreas Jonsson 		Details | Diff | Splinter Review
Bug 18705: collections_tracking itemnumber fk (2.80 KB, patch)
2024-10-10 05:30 UTC, Andreas Jonsson 		Details | Diff | Splinter Review
Show Obsolete (3) View All Add an attachment (proposed patch, testcase, etc.)

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.
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