[Mailman-Developers] Requirements for a new archiver

[Brad Knowles]

At 4:12 PM -0800 2003/10/29, Chuq Von Rospach wrote:

>  that's why I'm leaning, blob issues or no, towards full-text storage
>  in MySQL 4. Because if you can't easily chop up the message body
>  content and find the messages you want to deal with, elegant storage
>  of the headers is irrelevant...

	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.

-- 
Brad Knowles, <brad.knowles at skynet.be>

"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
     -Benjamin Franklin, Historical Review of Pennsylvania.

GCS/IT d+(-) s:+(++)>: a C++(+++)$ UMBSHI++++$ P+>++ L+ !E-(---) W+++(--) N+
!w--- O- M++ V PS++(+++) PE- Y+(++) PGP>+++ t+(+++) 5++(+++) X++(+++) R+(+++)
tv+(+++) b+(++++) DI+(++++) D+(++) G+(++++) e++>++++ h--- r---(+++)* z(+++)