On Oct 29, 2003, at 6:16 PM, J C Lawrence wrote:
I see two needs, for significantly different populations. The first wants a browsing interface with keyed and indexed by date, thread, and author. The second wands full text search with rapid location and retrieval of matching messages. Often a single user will move between the access methods, reading by thread, bouncing over to a search, then reading all an author has written that match, then searching again, etc. As such two distinct sets of indexes seem called for: full text and message meta-data.
I think you need that, too. But until you get a reasonable context search for the message body, designing the rest is silly.
Is searching message bodies really interesting, or is building indexes of message bodies such that you can later search those indexes the actually interesting point?
You're basically asking "why do you need google when you have yahoo?"
ask the folks who depend on google.
(and yes, I'm oversimplifying to make a point).
How does MySQL help you in building language-sensitive rapid response indexes of large text blobs?
just posted a bunch of links.