bug 2859: add index on bibioitems.issn (DB rev 006)
authorGalen Charlton <galen.charlton@liblime.com>
Thu, 11 Dec 2008 17:59:55 +0000 (11:59 -0600)
committerGalen Charlton <galen.charlton@liblime.com>
Fri, 12 Dec 2008 16:13:05 +0000 (10:13 -0600)
commitd3688945450f5034a906790d31663f0d45cdff82
treeeda65eeb5ce7fdf24fe01a6b58991b37fb87ec7d
parentae24c2d16ca462b5b311a3c4c265758de324d479
bug 2859: add index on bibioitems.issn (DB rev 006)

Because of a query on biblioitems.issn in
C4::Breeding::ImportBreeding(), libraries doing a lot
of bib imports were experiencing performance problems,
which adding an index will alleviate.

A possible longer term solution is to index all
reservoir/import batch records in a Zebra database.

[LL bug 232]

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl
kohaversion.pl