I'm starting to think that my current email archiving solution is sub-optimal.
The gzip/bzip2 archives I have are space-efficient, but are a pain when I want to look through them for that email from 3 months ago (or 2 years ago) that I deleted from my normal mailbox (which is the whole reason why I keep the archives).
I'm thinking of using something like MailTools to push my archives into a database (and maybe eventually call it from procmail to push all new messages into the db). I could then make a simple web application to search the archives.
Maybe I'll have some spare time this weekend to see how feasible it is.
Let me know what you come up with. I need a new archiving system too.
I'll be sure to post it here.