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: Main
Hardware: All All
: P5 - low major
Assignee: Fridolin Somers
QA Contact: Testopia
URL:
Keywords:
Depends on: 27946
Blocks:
  Show dependency tree / graph
 
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
Circulation function:

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
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 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 ﷐[U+1F984]﷑