[Mailman-Developers] Requirements for a new archiver

[Chuq Von Rospach]

On Oct 29, 2003, at 5:52 PM, Brad Knowles wrote:

> 	I think you could do full word indexing per message, and then store 
> that index information in the database.  Searching for phrases would 
> require hitting the message bodies themselves, but searching for 
> individual words could be done on indexed fields.
>

you could, but is it worth doing it yourself when MySQL is building it 
for you?

http://www.mysql.com/doc/en/Fulltext_Search.html

http://jeremy.zawodny.com/blog/archives/000576.html

http://www.zend.com/zend/tut/tutorial-ferrara1.php

If you were just storing into a TEXT and then doing SELECT LIKE into 
it, I'd agree with you. But MySQL is doing interesting things here. Why 
not leverage it?