[Koha] MySQL and foreign keys
paul.poulain at free.fr
Thu Jan 16 23:02:43 NZDT 2003
Chris Cormack a écrit:
>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
>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.
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Koha