iv>
On Sun, 07 Feb 2021 23:58:17 +1100
>
> I haven't gotten into the prel=
oad or DBI sharing yet - as that'll end
> up need=
ing a bit of a rewrite of code to take advantage of. I'd be
iv>
> open to suggestions here from those who have done it in the=
past to
> save me going down some dead ends :Dr>
I use mod_perl handlers, so not sure how it =
mixes with PerlRegistry, but you probably want to have a look at connect=
_cached
--
iv>
Bien =C3=A0 vous, Vincent Veyron
<=
br>
Logiciel libre de comptabilit=C3=
=A9 g=C3=A9n=C3=A9rale en partie double
>
--
The Wellcome Sanger Institut=
e is operated by Genome Research
Limited, a charity regist=
ered in England with number 1021457 and a
company register=
ed in England with number 2742969, whose registered
office=
is 215 Euston Road, London, NW1 2BE.
te>
--63510160839e4de487929329093dda5a--
--===============1354692886==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1354692886==--
--===============1354692886==
Content-Type: multipart/alternative;
boundary=63510160839e4de487929329093dda5a
--63510160839e4de487929329093dda5a
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: quoted-printable
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 i=
nto a whole world of pain. It isn't actually worth turning it on at all.=
>=20
> We use dedicated DB caching in the cases where we benefit from it as a=
nd when you need it (low level caching database)...
>=20
> Although milage may vary - our problem was DB servers with 30 or 40 da=
tabases on them being connected from a number of approximately 50-100 ch=
ild apaches, meant we ended up blowing up the connections to the databas=
e server really quickly...
>=20
>=20
> -----Original Message-----
> From: Vincent Veyron
=20
> Sent: 07 February 2021 19:06
> To: Steven Haigh
> Cc: James Smith ; modperl-at-perl.apache.org
> Subject: Re: Moving ExecCGI to mod_perl - performance and custom 'modu=
les' [EXT]
>=20
> On Sun, 07 Feb 2021 23:58:17 +1100
> Steven Haigh wrote:
> >=20
> > I haven't gotten into the preload or DBI sharing yet - as that'll en=
d=20
> > up needing a bit of a rewrite of code to take advantage of. I'd be=20=
> > open to suggestions here from those who have done it in the past to=20=
> > save me going down some dead ends :D
>=20
> I use mod_perl handlers, so not sure how it mixes with PerlRegistry, b=
ut you probably want to have a look at connect_cached
>=20
>=20
> --=20
>=20
> Bien =C3=A0 vous, Vincent Veyron=20
>=20
> https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__compta.libremen=
.com&d=3DDwIFAw&c=3DD7ByGjS34AllFgecYw0iC6Zq7qlm8uclZFI0SqQnqBo&r=3DoH2y=
p0ge1ecj4oDX0XM7vQ&m=3DC0OcuGbNbfxaSa8ASgV3uFXzejn7MpjIUH1aP1RbiyU&s=3DG=
Pr8VuKQ3rZCzCPwggyAHdCOojK6ZThmShKk0Jb3maI&e=3D
> Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie doubl=
e
>=20
>=20
>=20
> --
> 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.
>=20
--63510160839e4de487929329093dda5a
Content-Type: text/html;charset=utf-8
Content-Transfer-Encoding: quoted-printable
what's DBI shar=
ing? do you mean Apache::DBI?
Does perl has Java similar D=
B connection pool?
Thanks.
div>
On Mon, Feb 8, 2021, at 4:21 AM, James Smith wrote:
lockquote type=3D"cite" id=3D"qt" style=3D"">DBI sharing doesn't re=
ally gain you much - and can actually lead you into a whole world of pai=
n. 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)...
r>
Although milage may vary - our problem was DB servers with =
30 or 40 databases on them being connected from a number of approximatel=
y 50-100 child apaches, meant we ended up blowing up the connections to =
the database server really quickly...
<=
/div>
-----Original Message-----
Sent: 07 February 2021 19:06
Subject: Re: Moving ExecCGI to=
mod_perl - performance and custom 'modules' [EXT]
iv>
On Sun, 07 Feb 2021 23:58:17 +1100
>
> I haven't gotten into the prel=
oad or DBI sharing yet - as that'll end
> up need=
ing a bit of a rewrite of code to take advantage of. I'd be
iv>
> open to suggestions here from those who have done it in the=
past to
> save me going down some dead ends :Dr>
I use mod_perl handlers, so not sure how it =
mixes with PerlRegistry, but you probably want to have a look at connect=
_cached
--
iv>
Bien =C3=A0 vous, Vincent Veyron
<=
br>
Logiciel libre de comptabilit=C3=
=A9 g=C3=A9n=C3=A9rale en partie double
>
--
The Wellcome Sanger Institut=
e is operated by Genome Research
Limited, a charity regist=
ered in England with number 1021457 and a
company register=
ed in England with number 2742969, whose registered
office=
is 215 Euston Road, London, NW1 2BE.
te>
--63510160839e4de487929329093dda5a--
--===============1354692886==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1354692886==--
