RE: Slow connection to Oracle 9i

[Paul Appleby]

No. Each user will be using the same application that logs in to the 
same schema. But the users are all anonymous visitors to a web site.

Paul
Are you logging in each user to a unique oracle schemna? 
If so, no hope... (other than oracle tuning per Tim's message --
pre-spawned listeners on the database can make a BIG difference ... talk to
your dba's)

Lincoln

-----Original Message-----
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 4:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
My CGI application will be called by different users at different
times. Are you saying the first user's connection can be left open
for all the other users? How?
Paul
Most people with experience with Oracle know that opening oracle
connections
is SLOW!
Oracle does not appear to consider that a problem, just like they do not
consider slow performance for doing DDL a problem
Applications that require near real time (OLTP) response times open
connections once, and hold open oracle connections across transactions.
This is true regardless of the language on the client side.  That is why,
for instance, Websphere caches pooled connections in the java world.
Lincoln
-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 12:06 PM
To: Paul Appleby
Cc: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
  >DBD::Oracle::dr::load_dbnames is only called by data_sources()
  >so don't call data_sources() unless you really need to.
  I really do need to call  data_sources() but the time it takes to
  retrieve data, as shown above, using "Time::HiRes" is only
  0.0100140571594238 seconds. So that's not the issue.
dprofpp showed it to take approx the same time as login:
  %Time ExclSec CumulS #Calls sec/call Csec/c  Name
   21.6   0.090  0.090      1   0.0900 0.0900  DBD::Oracle::db::_login
   21.6   0.090  0.159      1   0.0899 0.1592
DBD::Oracle::dr::load_dbnames
   21.6   0.090  0.159      6   0.0149 0.0265  main::BEGIN
Anyway, I think there's little you can do from DBI to make Oracle
connections faster than you already have.  Look to changes on the
Oracle side - for which other mailing lists (such as oracle-l) are
more suitable.
Tim.

--
Sincerely,
Paul Appleby

--
Sincerely,
Paul Appleby