http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9681
Bug ID: 9681
Summary: Add some indexes in database
Classification: Unclassified
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Some table columns should have an index to speed SQL queries :
- statistics table has only one index (used to make heavy queries for reports)
- itemtype should have an index in items and biblioitems (this is used in
circulation to check the number of existing issues of a specific item type)
- issue.branchcode and issue.issuingbranch
Note that the fact that an index is automatically created for foreign keys in
InnoBD seems to be in discussion, so better create it explicitly.
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://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/
