Bug 30479 - Add index for dateaccessioned in items table
Summary: Add index for dateaccessioned in items table
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: MARC Bibliographic data support (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-07 00:41 UTC by David Cook
Modified: 2022-04-07 00:41 UTC (History)
0 users

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Cook 2022-04-07 00:41:29 UTC
Dateaccessioned is a common column used for querying items (like in the coverflow plugin: https://github.com/bywatersolutions/koha-plugin-coverflow), and it can be a bit slow on large datasets, so we're suggesting adding an index to the items table for dateaccessioned.