what's DBI sharing? do you mean Apache::DBI? Does perl has Java similar DB connection pool?
Thanks. On Mon, Feb 8, 2021, at 4:21 AM, James Smith wrote: > DBI sharing doesn't really gain you much - and can actually lead you into a > whole world of pain. It isn't actually worth turning it on at all. > > We use dedicated DB caching in the cases where we benefit from it as and when > you need it (low level caching database)... > > Although milage may vary - our problem was DB servers with 30 or 40 databases > on them being connected from a number of approximately 50-100 child apaches, > meant we ended up blowing up the connections to the database server really > quickly... > > > -----Original Message----- > From: Vincent Veyron <vv.li...@wanadoo.fr> > Sent: 07 February 2021 19:06 > To: Steven Haigh <net...@crc.id.au> > Cc: James Smith <j...@sanger.ac.uk>; modperl@perl.apache.org > Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modules' > [EXT] > > On Sun, 07 Feb 2021 23:58:17 +1100 > Steven Haigh <net...@crc.id.au> wrote: > > > > I haven't gotten into the preload or DBI sharing yet - as that'll end > > up needing a bit of a rewrite of code to take advantage of. I'd be > > open to suggestions here from those who have done it in the past to > > save me going down some dead ends :D > > I use mod_perl handlers, so not sure how it mixes with PerlRegistry, but you > probably want to have a look at connect_cached > > > -- > > Bien à vous, Vincent Veyron > > https://urldefense.proofpoint.com/v2/url?u=https-3A__compta.libremen.com&d=DwIFAw&c=D7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=oH2yp0ge1ecj4oDX0XM7vQ&m=C0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=GPr8VuKQ3rZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e= > Logiciel libre de comptabilité générale en partie double > > > > -- > The Wellcome Sanger Institute is operated by Genome Research > Limited, a charity registered in England with number 1021457 and a > company registered in England with number 2742969, whose registered > office is 215 Euston Road, London, NW1 2BE. >
