[Koha-bugs] [Bug 9681] New: Add some indexes in database

[bugzilla-daemon at bugs.koha-community.org]

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: gmcharlt at gmail.com
          Reporter: fridolyn.somers at biblibre.com

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.