RE: Persistent DB connections

2008-04-22 Thread Christoph Petersen
Hi Michael, > Really? Thats interesting, in all my tests MySQL has always done well, > it is very cheap to recreate MySQL connections so the DBI Persistence > plugin has never been a big win at all for MySQL. > Yeah it is performing well. But I guess here is some space to tweak. SA is currently

RE: Persistent DB connections

2008-04-22 Thread Christoph Petersen
Hi Michael, > > for my setup I use a MySQL DB as the store for bayes and AWL. Every > > process > > is opening, querying and closing his own DB connection which results > > in > > latency and is not necessary. > > Really? Thats interesting, in all my tests MySQL has always done well, > it is very

Re: Persistent DB connections

2008-04-22 Thread Michael Parker
On Apr 22, 2008, at 5:31 AM, Christoph Petersen wrote: He guys, for my setup I use a MySQL DB as the store for bayes and AWL. Every process is opening, querying and closing his own DB connection which results in latency and is not necessary. Really? Thats interesting, in all my tests MyS

Re: Persistent DB connections

2008-04-22 Thread Michael Scheidell
> From: Henrik K <[EMAIL PROTECTED]> > Reply-To: > Date: Tue, 22 Apr 2008 13:43:41 +0300 > To: > Subject: Re: Persistent DB connections > > On Tue, Apr 22, 2008 at 12:31:09PM +0200, Christoph Petersen wrote: >> >> Is there another plugin which can ach

RE: Persistent DB connections

2008-04-22 Thread Christoph Petersen
> On Tue, Apr 22, 2008 at 12:52:42PM +0200, Christoph Petersen wrote: > > Any other ideas? > > Patches welcome. ? :) Perl is a long time ago... Maybe another Summer of Code project would trigger the ambition of a poor student :P Just kidding! > > -- > Randomly Selected Tagline: > "If you eve

Re: Persistent DB connections

2008-04-22 Thread Theo Van Dinter
On Tue, Apr 22, 2008 at 12:52:42PM +0200, Christoph Petersen wrote: > Any other ideas? Patches welcome. ? :) -- Randomly Selected Tagline: "If you ever reach total enlightenment while drinking beer, I bet it makes beer shoot out your nose." - Deep Thought, Jack Handy pgp7Sh1kxnheO.pgp Desc

RE: Persistent DB connections

2008-04-22 Thread Christoph Petersen
Hi Henrik, > On Tue, Apr 22, 2008 at 12:31:09PM +0200, Christoph Petersen wrote: > > > > Is there another plugin which can achieve persistent db connections? > Or some > > clues to fix the abovementioned issues? > > http://wiki.apache.org/spamassassin/DBIPlugin Used the predecessor of this plugi

Re: Persistent DB connections

2008-04-22 Thread Henrik K
On Tue, Apr 22, 2008 at 12:31:09PM +0200, Christoph Petersen wrote: > > Is there another plugin which can achieve persistent db connections? Or some > clues to fix the abovementioned issues? http://wiki.apache.org/spamassassin/DBIPlugin If you use amavisd-new: http://marc.info/?l=amavis-user&m=

Re: Persistent DB connections for bayes_sql module.

2005-07-20 Thread Michael Parker
Matthew Schumacher wrote >Anyone have any ideas on how to fix this? > > http://bugzilla.spamassassin.org/show_bug.cgi?id=2037 Michael signature.asc Description: OpenPGP digital signature

Re: Persistent DB connections for bayes_sql module.

2005-07-20 Thread Matthew Schumacher
Matthew Schumacher wrote: > List, > > I moved my SA bayes store into my postgres database because I was > running into locking issues with the Berkeley DB. > > The database is up and running fine, but I noticed that that connections > to the database are not persistent. As many of you know, post