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



On 11/16/06, Chris Drake <christopher@xxxxxxxxx> wrote:

I'm expanding, and adding extra web servers to handle my load. My
Apache/mod_perl environment maintains a new connection for each process, and
these processes seem to chew up a lot of server resources.



Check out connection pooling.

I have not used it, but it is designed for your scenario.
You do need a test environment that mimics production
to really test an implementation of this.

http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14212/intro.htm#sthref67



--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Relevant Pages

  • Re: A REAL LIVE Reverse Entropy Machine-Warning
    ... it spins a environment too ... evolutionary out of her fantastic summer. ... For Cathy the notebook's ... surprised, in connection with me it's cosmetic, whereas relative to you it's ...
    (sci.crypt)
  • Re: fSMORoleOwner in CN=Infrastructure DomainDNSZones & ForestDNSZ
    ... all dc's are current & actually show up correctly with FSMO roles. ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... Always test ANY suggestion in a test environment before implementing! ...
    (microsoft.public.windows.server.active_directory)
  • Re: DTS Environment Control
    ... In the pakcgaes the connectionnames for the server stay the same. ... as I promote my packaged from DEV to TEST - If I'm ... > Test Environment: ... > 1) Connection Source to SQL TEST Box ...
    (microsoft.public.sqlserver.dts)
  • Re: fSMORoleOwner in CN=Infrastructure DomainDNSZones & ForestDNSZ
    ... NETDOM QUERY FSMO ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... Always test ANY suggestion in a test environment before implementing! ...
    (microsoft.public.windows.server.active_directory)
  • hardly any spanish solar supplier objects beings no doubt Ibrahims central grace
    ... rub satisfactory spells, do you let them? ... reserve after Rashid presumes the overall mainland's environment? ... furnish Andrew's beach in connection with sinks, ... surprised requirements spring no longer the valuable cabinet. ...
    (sci.crypt)