Hi Simon,

Basically we have a webmail service, which connects to 4 different IMAP servers via perdition. As I said there is 13,000+ entries in popmap.re, using this format: (.*)@domain.com: 123.123.123.123

We have a script which reloads perdition every hour as changes are made to popmap.re frequently. The problem is when a user first attempts to login they experience a delay in authenticating. Each time this happens the perdition.imap4 process consumes 100% cpu for about 60 seconds, after about 30 seconds there are 3 perdition.imap4 processes all consuming cpu usage.

I suspect that because the contents of popmap.re is so large, perdition is taking longer to process the request.

thanks,
Stephen

On Wed, Jan 21, 2009 at 11:04 AM, Simon Horman <horms@verge.net.au> wrote:
On Wed, Jan 21, 2009 at 10:28:13AM +1100, Stephen Vaughan wrote:
> Hi,
>
> Is it possible to store regular expressions in a mysql database? We have
> over 13,000 RE's in our popmap.re and understandably each time a user
> authenticates its taking a long time to process the request.

Hi Stephen,

I'd need to understand a bit more about what you are doing in order to
suggest a solution to that problem. But to answer your question, no
perdition doesn't support storing regexes in MySQL directly. I suspect that
either adding a specialised popmap, or to write a daemon that returns
results to the daemon map.

--
Simon Horman
 VA Linux Systems Japan K.K., Sydney, Australia Satellite Office
 H: www.vergenet.net/~horms/             W: www.valinux.co.jp/en




--
Best Regards,
Stephen