http://www.perlmonks.org?node_id=149833


in reply to Re: Managing a Personal Email Archive
in thread Managing a Personal Email Archive

After a little more digging, it appears the Pronto is a fork of CSCMail. The Pronto site says it was forked when CSCMail went to C. The CSCMail faq says version 2 will be in C w/o SQL. But the current version 1.6.2 is still in perl/gtk. His reasoning for no DB makes sense to me. So you decide. :-)

Why do you need the message store to be a SQL database?

  • Comment on Re: Re: Managing a Personal Email Archive

Replies are listed 'Best First'.
Re: Re: Re: Managing a Personal Email Archive
by dave_aiello (Pilgrim) on Mar 07, 2002 at 12:33 UTC
    > Why do you need the message store to be a SQL database?

    I thought a SQL database was the answer because I might have 50,000 archived messages today, and I am accumulating non-trivial, non-SPAM mail at a rate of 25,000 messages a year at an annual growth rate in excess of 50 percent per year. (Aside: it would be a lot easier to keep statistics on a mail archive if it was in a SQL database.)

    I assume that performance of the search function would be better with a SQL-based archive, and the performance would stay relatively constant as the size of the archive grows.

    Dave Aiello
    Chatham Township Data Corporation