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?
_______________________________________________ Mailman-Developers mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-developers
