Summary: | collections_tracking-table is missing index/foreign key to items | ||
---|---|---|---|
Product: | Koha | Reporter: | Olli-Antti Kivilahti <olli-antti.kivilahti> |
Component: | Circulation | Assignee: | 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
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 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 Please rebase Still valid. 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 Can we get a test plan? https://wiki.koha-community.org/wiki/Commit_messages 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 |