On Thu, 17 Sep 2009 23:52:24 +0200, Michael Monnerie <[email protected]> wrote: > 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 don't think any database's own full text index will really do what we want for IMAP. I'd love to bolt on Sphinx or something like it and have it manage the search index out of band. http://www.sphinxsearch.com/ >> 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. Supporting SQLite is a great feature; it's important to be able to configure for a single shard and remain on a single host. >> 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 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
