https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25661
Bug ID: 25661
Summary: auth_header missing authtypecode index
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: koha-bugs@lists.koha-community.org
Reporter: dc...@prosentient.com.au
QA Contact: testo...@bugs.koha-community.org
While code like tools/export.pl and Koha/MetadataRecord/Authority.pm all seem
to rely primarily on the authid primary key, it seems to me that there are
scenarios where you want to report on authority records using only the
authtypecode field.
At the moment, the database has to do a row scan through every auth_header row
in order to determine which records to return.
If we used an authtypecode index, the database would be able to process the
search query much quicker and do much less work on the backend.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
