I recommend trying Sphinx. Most of the hard work has been taken care of already.
-----Original Message----- From: Ben [mailto:ben@forlent.com] Sent: Wednesday, October 17, 2007 12:16 PM To: dev@lists.roundcube.net Subject: [RCD] Fulltext message searching
Hello,
Has a fulltext message searching feature been considered? I think it would be very handy. It could use a MySQL table to store hashes of the message text (with all HTML, nontext characters, and other formatting removed to reduce size). When a search is performed, it could utilize MySQL's FULLTEXT feature to deliver lightning fast search results similar to gmail, hotmail, etc.
It could maybe have an automated indexer that works in the background indexing one or two unindexed messages at a time on each ajax request from the browser (after the data is returned to the browser to prevent lagging).
The feature could of course be turned off (maybe off by default?) if the user didn't want to use the extra diskspace/processor cycles.
Does this sound like something you'd like to see in RC? If so, I can develop the backend for this system if somebody else can write the interface/ajax integration.
Thanks, Ben
List info: http://lists.roundcube.net/dev/ _______________________________________________ List info: http://lists.roundcube.net/dev/