Bug 30852 - article_requests missing index on debit_id
Summary: article_requests missing index on debit_id
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: master
Hardware: All All
: P5 - low major (vote)
Assignee: Fridolin Somers
QA Contact: Testopia
URL:
Keywords:
Depends on: 27946
Blocks:
  Show dependency treegraph
 
Reported: 2022-05-26 06:25 UTC by Fridolin Somers
Modified: 2023-06-08 22:26 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: Trivial patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
22.05.00


Attachments
Bug 30852: Add index on article_requests.debit_id (2.02 KB, patch)
2022-05-26 06:37 UTC, Fridolin Somers
Details | Diff | Splinter Review
Bug 30852: DBRev 21.12.00.057 (1.25 KB, patch)
2022-05-26 06:38 UTC, Fridolin Somers
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Fridolin Somers 2022-05-26 06:25:25 UTC
Bug 27946 added foreign key in article_requests on debit_id.
This column needs a performance index.
Comment 1 Fridolin Somers 2022-05-26 06:37:27 UTC
I SO and PQA, this is needed for the release
Comment 2 Fridolin Somers 2022-05-26 06:37:58 UTC
Created attachment 135358 [details] [review]
Bug 30852: Add index on article_requests.debit_id

Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Comment 3 Fridolin Somers 2022-05-26 06:38:13 UTC
Created attachment 135359 [details] [review]
Bug 30852: DBRev 21.12.00.057

Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Comment 4 Fridolin Somers 2022-05-26 06:39:05 UTC
Pushed to master for 22.05, thanks to everybody involved 🦄