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



On 2006-11-19 18:43:15 +1100, Ron Savage wrote:
On Sat, 18 Nov 2006 13:02:26 +1100, Chris wrote:
Doing some digging around, I discover that each Oracle connection
consumes 4megs of RAM when "doing nothing".

:-(.

Is that with or without MTS?


It would seem that I will definitely need some kind of connection
pooling - does anyone disagree ?

Lateral thinking would suggest a smarter database server :-).

MTS *is* designed to allow many concurrent connections to the database
with (relatively) little RAM usage. The arguments against MTS I've read
in the articles referenced in this thread were all along the lines of
"modern database servers have more than enough RAM, so MTS is obsolete".
(Probably not only because of increasing RAM sizes but also because
people are migrating from forms-based applications to web-based
applications, which can support many per DB connection).

I'm wondering about the design of the web application, though: 2000+
apache processes all pounding on the same database does sound a bit
strange. I suspect that there would be some optimization potential in
the web server configuration (I haven't seriously played with mod_perl2
yet, but I vaguely remember seeing parameters which might be helpful for
this. Reverse proxy has already been mentioned. Fastcgi might also be
a possible solution.)

hp



--
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@xxxxxxxxx | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

Attachment: pgpNfMynUFRIo.pgp
Description: PGP signature



Relevant Pages

  • Re: performance optimization?
    ... need more RAM. ... Only if your machine is IO limited by your hard drives does it make much ... I do run database software and even with that I have ... # semaphore maximum value: 32767 MAX ...
    (comp.os.linux.misc)
  • Re: out of memory
    ... read only the smaller file into a hash. ... the smaller file will fit into RAM. ... Depending upon the sorting algorithm this would be Ologor ... put your relevant data into a database and use ...
    (comp.lang.perl.misc)
  • ANN: NexusDB Breaks the 2GB database RAM cache barrier
    ... Your customer has a huge database with many gigabytes of data. ... Unfortunately, because RAM for the ... You could for instance run NexusDB Server AWE ... The best part of the NexusDB Serer AWE edition is that it is a drop-in ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Embedded Database Recommendations?
    ... 1GHz and 1GB RAM. ... Number of concurrent users (access to database) ... Number of SELECT requests per min/per hour... ... so determines how fast a storage unit, ...
    (comp.arch.embedded)
  • Re: card catalog program?
    ... disk files that have databases related to book libraries. ... 768K of RAM at the time. ... by Appleworks with a 1MB RAMworks-style memory card and AE's Appleworks ... wonder how many could fit in memory for a standard-size database ...
    (comp.sys.apple2)