Jonathan Feally wrote: > Michael Monnerie wrote: >> On Donnerstag 17 September 2009 Paul J Stevens wrote: >> >>> No way around that without full text indexing. >>> >> Any chance to have FTI support? PostgreSQL 8.3 has that built-in AFAIK, >> so it could be interesting. Dbmail could support it if the DB supports >> it, I just don't know how much effort that would be. Maybe just a >> configuration line, or auto-detection? >> >> mfg zmi >> > > 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'd rather investigate the viability of an external indexer like lucene/solr, extending the earlier design work I did: http://www.dbmail.org/dokuwiki/doku.php/bodysearch > 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. I beg to differ here. SQLite kicks ass. One main use case for me for developing hydra would be kinda like what Geo did a couple of years ago when he donated the original sqlite driver: give each user his own sqlite database. But then again, our ideas of what hydra should be are not yet set in stone. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
