Bug 30479

Summary: Add index for dateaccessioned in items table
Product: Koha Reporter: David Cook <dcook>
Component: MARC Bibliographic data supportAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

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.