[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-devel] DB design (MARC structure)

From: Paul POULAIN
Subject: [Koha-devel] DB design (MARC structure)
Date: Mon Jun 14 02:00:02 2004
User-agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.6) Gecko/20040115

Hello all,

Nelsonville & me are trying to optimize queries.
I'm concluding we should modify a little the DB :
* marc_word has "tag", "subfield" and "word" fields.
* we are querying on tag+subfield in ('200a','245f') and word like 'tower%' . Such a query CANNOT be optimised by mySQL.
* so, an index on (tag, subfield,word) is not used.
* I think we could highly optimize the search with a field called 'tagsubfield', an index on (tagsubfield,word). The search being tagsubfield in ('200a','245f') and word like 'tower%'.

Other searches (a search on "keyword", that does is done only on word, not on tag+subfield) will still be working fast, with index on (word)

Does this make sense ? Any comment ?
if yes, i'll do it (for friday).
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)

reply via email to

[Prev in Thread] Current Thread [Next in Thread]