I guess the DBA's don't like it because Oracle starts one process per
connection unless you use connection pooling.
I think that's a listener setting, your DBA's should know.
--
Best regards, Alex
Am Mittwoch, den 08.09.2010, 16:54 +0200 schrieb Simon Miner:
> Thanks for the responses,
>
> Jason
On 8 Sep 2010, at 19:17, Javier Arturo Rodriguez wrote:
On 9/8/10 4:54 PM, Simon Miner wrote:
The parameters defining the connection have to be exactly the same,
including the connect attributes! If there is no appropriate
database handle or if the ping method fails, a new connection i
On 9/8/10 4:54 PM, Simon Miner wrote:
Thanks for the responses,
Jason, I don't think reducing the number of database connections will
hurt responsiveness. Even though there are 3 separate Catalyst apps,
each HTTP request will only involve one of them (since they all run
out of the same web
(Hopefully I'm not out of my depth here)
I feel your pain WRT Oracle connections as we've had similar complaints from
our DBA overlords about the number of connections our app was making here at
$work. Do you have your mod_perl processes behind some sort of proxy? If
you run your mod_perl applic
Sounds like a job for DBD::Proxy or DBD::Gofer, not that I've ever
used them, and I have no idea whether they would play nice with DBIC --
the DBIC folks would have a better grasp on that question. That would
leave the Catalyst parts unchanged apart from configuration, which would
be a good th
Thanks for the responses,
Jason, I don't think reducing the number of database connections will hurt
responsiveness. Even though there are 3 separate Catalyst apps, each HTTP
request will only involve one of them (since they all run out of the same
web server), so there should never be contention
I'm with Tom on this one. Unless you've narrowed all optimization efforts
and this is all you have left - it could be worth a try.. but as Jason
points out, you may not gain a thing. I'd recommend profiling your code and
tracking down performance issues from that base level. Please post your
result
On 7 Sep 2010, at 18:59, Simon Miner wrote:
All three of these apps run under a single Apache 1.3.42/mod_perl
1.31 server.
Wow, mod_perl 1 Ok then :)
It appears that each server process creates a unique database
connection variable for each of these apps. Although these database
con
Hi Simon,
Reducing the number of connections to the database from three to one
will reduce the responsiveness and will definitely hurt when trying to
debug issues (performance, etc). My recommendation is that each
application have at least one unique connection to the database.
jason
On 0
Hi,
I am running 3 separate Catalyst (version '5.80022) apps that use a common
(Oracle 11g) database. Each app has a model class which wraps around a
common DBIC schema class, like so.
-
package App1::Model::DB;
use strict;
use base 'Catalyst::Model::DBIC::Schema';
__PACKAGE__->confi
10 matches
Mail list logo