I recommend trying Sphinx. Most of the hard work has been taken care of already.
http://www.sphinxsearch.com/ -----Original Message----- From: Ben [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 12:16 PM To: [email protected] 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/
