[Koha] MySQL and foreign keys

[paul POULAIN]

Chris Cormack a écrit:

>Hi There
>
>Just to throw in my 2 cents worth, i dont see using mysql fulltext searching
>as ruling out db independence.
>It just forces us to code more carefully, perhaps setting a value in
>/etc/koha.conf usefulltext=yes  or the like. Which we can then use to decide
>whether to make a standard like search, or to use a fulltext index.
>
BUT : the standard like search is UNUSEABLE on a 50 000+ biblio DB, as 
every search means a full parsing of the table.
If you add the same thing for the thesaurus table, which is widely used 
in marc cataloguing, and some other place where full text indexing will 
be usefull...

>I think database independence is a laudible aim, but id hate to see it rule
>out potential optimisations also. There is a always a tradeoff and its a
>matter of balance.
>
>Chris
>
-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20030116/18a18857/attachment-0001.htm