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)
  • 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: Issues with Store.exe dying during Backup (using Backup Exec 10)
    ... database is basically a big mapped file. ... fit into RAM, so eachange maps pages into RAM, more specifically the ... When buffers in RAM become ... during a brick level backup would make sense in this scenario; ...
    (microsoft.public.exchange.admin)
  • Re: Modeling events that occur in a game world
    ... A good DB only goes to disk when RAM is not available. ... Which DBs can you imbed completely in memory like this? ... In biz apps a database is usually available and assumed available. ...
    (comp.object)