[Koha-devel] DB design (MARC structure)

[Paul POULAIN]

Paul POULAIN a écrit :

> Joshua Ferraro a écrit :
>
>> 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
>>
> ok, it's commited.
> works fine on a small DB.

works fine on your DB too :

EXPLAIN SELECT DISTINCT m1.bibid
FROM biblio, biblioitems, marc_biblio, marc_word AS m1
WHERE biblio.biblionumber = marc_biblio.biblionumber AND 
biblio.biblionumber = biblioitems.biblionumber AND m1.bibid = 
marc_biblio.bibid AND (
m1.word
LIKE 'wolf%' AND m1.tagsubfield
IN (
'245a'
)
)
ORDER BY biblio.title


table     type     possible_keys     key     key_len     ref     rows 
    Extra
m1     range     bibid,word,Marc_Search     Marc_Search     259     NULL 
    114     Using where; Using temporary; Using filesort
marc_biblio     eq_ref     PRIMARY,biblionumber     PRIMARY     8     
m1.bibid     1     Using where; Distinct
biblio     eq_ref     PRIMARY,blbnoidx     PRIMARY     4     
marc_biblio.biblionumber     1     Distinct
biblioitems     ref     bibnoidx     bibnoidx     4     
biblio.biblionumber     1     Using index; Distinct

we can't do better ;-)

NB : to have something working well :
* copy your 2.0 DB
* run updatedatabase.
(all indexes should be created. Be patient, 5-6 hours needed on your 
marc_word table)

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)