Re: Regular expressions
Stephen Vaughan <[email protected]>
| Newsgroups | gmane.mail.perdition.user |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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/ <http://www.vergenet.net/%7Ehorms/> > W: www.valinux.co.jp/en > > -- Best Regards, Stephen ______________________________________________ Perdition-users mailing list [email protected] http://lists.vergenet.net/listinfo/perdition-users