On Donnerstag 17 September 2009 Jonathan Feally wrote: > FTI would help searching greatly, however on MySQL the default is to > only index words 4 chars or longer. Thus it makes it unreliable when > searching for a small word of 3 chars or less. You can change it to > index 3 chars, which would probably be sufficient, but since this is > a global change on the whole database server and would require a > restart, not everyone would be able to use it (hosted databases). I > am unsure of SQLite FTI. I really can't see support of SQLite > remaining beyond 2.4 because of the multi-server over a network > requirement of 2.5 Hydra.
That's why I said it maybe should be configurable. There's always somebody/something not wanting/supporting that feature, but it could help those with the capabilities to use it. > Do you know what PostgreSQL does in as far as what is indexed? No. I just read on the pg-users ML that 8.3 has that, and we are on 8.4 already. So maybe support is even better there. But I never used it, not having a program using it.... mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
