Summary: | collections_tracking-table is missing index/foreign key to items | ||
---|---|---|---|
Product: | Koha | Reporter: | Olli-Antti Kivilahti <olli-antti.kivilahti> |
Component: | Circulation | Assignee: | Andreas Jonsson <andreas.jonsson> |
Status: | Failed QA --- | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | andreas.jonsson, caroline.cyr-la-rose, gmcharlt, josef.moravec, kyle.m.hall, shi-yao.wang |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | 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 Hi Olli-Antti, There is still no test plan for this. Could you provide some information as to how this needs to be tested? Thanks! Oops, sorry, I said Olli-Antti, but it seems Andreas has taken this bug :) |