Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- From: dispo41@xxxxxxxxxxx (Chris)
- Date: Sat, 18 Nov 2006 13:02:26 +1100
Doing some digging around, I discover that each Oracle connection consumes
4megs of RAM when "doing nothing".
that would add up to 8gigs for 2000 connections... and since I've only got
8gigs in total, this is about 4 times more than I can spare.
It would seem that I will definitely need some kind of connection pooling -
does anyone disagree ?
# pmap -d 13040 | tail -1
mapped: 810872K writeable/private: 3392K shared: 722944K
.
- Follow-Ups:
- References:
- RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- From: Philip Garrett
- Re[2]: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- From: Chris Drake
- Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- From: Robert Hicks
- RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Prev by Date: Perl5.8 Oracle DBI connects failing
- Next by Date: RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Previous by thread: Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Next by thread: Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
- Index(es):
