[Top][All Lists]

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

Re: [Koha-devel] DB design (MARC structure)

From: Joshua Ferraro
Subject: Re: [Koha-devel] DB design (MARC structure)
Date: Mon Jun 14 04:41:01 2004
User-agent: Mutt/1.4.1i

If I understand it correctly this sounds like a great solution to
our speed issues with the current marc searching--and it won't 
compromise the accuracy of the search either.  Let's do it.


On Mon, Jun 14, 2004 at 10:59:03AM +0200, Paul POULAIN wrote:
> 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]