SQL Storage for fast retrieval from archives

[Kjetil Torgrim Homme]

On Fri, 2006-09-01 at 18:41 +0530, Ramprasad wrote:
> Hi,
>   I am trying to use cyrus for my mail archives ( typically 1GB-10GB per
> user ) for say 100 users 
> 
> What is the best way of storing mails. There will not be much of
> add/delete from these archives but retrieval has to be fast on header or
> body search. 
> 
> Cyrus with the current storage ( one mail per file ) is good enough for
> header search , but fails on body search. 

why?

> Does cyrus have an option to store in MySQL etc. I think body search
> will be much faster with SQL

did you try the squatter?

-- 
Kjetil T.