[Koha-bugs] [Bug 18048] New: Add index on biblioitems.ean

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18048

            Bug ID: 18048
           Summary: Add index on biblioitems.ean
 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: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org

In big databases querying on the EAN can take a while, it would be nice to have
an index on this column as we have on other columns with standard numbers in
this table already:

 196   PRIMARY KEY  (`biblioitemnumber`),
 197   KEY `bibinoidx` (`biblioitemnumber`),
 198   KEY `bibnoidx` (`biblionumber`),
 199   KEY `itemtype_idx` (`itemtype`),
 200   KEY `isbn` (`isbn`(255)),
 201   KEY `issn` (`issn`(255)),
 202   KEY `publishercode` (`publishercode`),

-- 
You are receiving this mail because:
You are watching all bug changes.