RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?

It sounds to me like you have a good case for using some type of
pooling.

Here are a few options off the top of my head:
1) Pooling via SQLRelay
2) Pooling via MTS
3) Use fewer mod_perl processes by putting a lightweight
reverse proxy in front of them. This doesn't pool
connections, just reduces the number of connections required.
See Stas Bekman's overview at http://tinyurl.com/y5k8ka
(perl.apache.org) if you haven't already.

You might also want to consider aggressive caching (memcached perhaps?)
to take some load off of your database server.

Regards,
Philip

-----Original Message-----
From: Chris [mailto:dispo41@xxxxxxxxxxx]
Sent: Friday, November 17, 2006 9:02 PM
To: dbi-users@xxxxxxxx
Subject: Re: How should I connect via DBD::Oracle to efficiently obtain
2000+ simultaneous connections?

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


.

Relevant Pages

  • Re: Question about Connection Pooling in ASP
    ... you almost have to deliberately turn off connection pooling in order ... As long as you are talking about storing a string in Application, ... pooling is used for all connections using that string. ... using connected recordsets, instead of utilizing GetString, GetRows ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to close connection pool?
    ... Simply open connections with pooling disabled--or as suggested when ... Microsoft MVP ... pool preventing it until the user exits the application. ... so I need to set pooling to false for that action. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Disable .Net Connection Pooling thru SQLDMO
    ... -- -oj "Rob Kraft" wrote in message ... >I would like to disable the .Net connection Pooling. ... I have a conversion> pgm using SQLDMO and .Net that needs to kill its own connections, ...
    (microsoft.public.sqlserver.programming)
  • Re: Global data concurrent access ?
    ... No pooling 1000 iterations. ... Elapsed time: 00:00:12.9217096 ... affects pooled connections (makes sense; ...
    (microsoft.public.dotnet.framework)
  • Re: ADO - Bad when it is time to Optimize
    ... in COM-ATL and the data access is thru ADO to SQL. ... You cannot set the max pool size. ... There is no way to disable the pooling ... You cannot know whether non-pooled connections are happening ...
    (microsoft.public.data.ado)