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

I will second the memcache suggestion. (his other solutes age good as
well).

It is quick and easy to use with a good perl interface that will take
quite the load of the DB especially if you have alot of static data.

A very quick and easy solution.

here is the link to memcache

http://www.danga.com/memcached/


""Garrett, Philip (MAN-Corporate)"" <Philip.Garrett@xxxxxxxxxxx> wrote in
message news:D9C13100F14E4C4795A1E83B125B40350232B7BD@xxxxxxxxxxxxxxxxxxxx
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

  • Memcache failover
    ... I've started playing with memcache in development for a large-ish site ... to handle sessions with 1 memcache server. ... I have something like this that sets up a connections to all the ... error like this when I try and get something from the memcache pool: ...
    (php.general)
  • 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: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
    ... Here are a few options off the top of my head: ... Pooling via SQLRelay ... connections, just reduces the number of connections required. ... to take some load off of your database server. ...
    (perl.dbi.users)
  • Re: Global data concurrent access ?
    ... No pooling 1000 iterations. ... Elapsed time: 00:00:12.9217096 ... affects pooled connections (makes sense; ...
    (microsoft.public.dotnet.framework)