Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> An astonishingly slow DB opening

An astonishingly slow DB opening

From: F Quednau <fquednau_at_realfiction.net>
Date: 23 Jul 2001 09:56:41 -0700
Message-ID: <5650f27e.0107230856.1535777@posting.google.com>

Hello there people,
I am confused and I don't even know to which group to post. I have a win2k SP2 connecting through ADO 2.6 SP1 and Oracle Client 8.1.7 to an Oracle Database 8.1.6

From a VB component in Comp. Services (does not support transaction) I connect through ORAOLEDB.Oracle and it takes me currently almost half a minute (!) to connect first time. After pooling kicks in, the stuff is as I got used to again.
The same connection built into a VB App takes about 2 seconds on the same machine, the sort of number I got used to throughout other setups.

Anyone knows how this sort of behaviour can occur? And while I am here, does the Oracle MTS Service have any relevance in the win2k world of com+ ?

Here the connect thing, indeed unchanged within the component and the application
--> time here

  Set DBCon = New ADODB.Connection
  With DBCon
    .Provider = "OraOLEDB.Oracle"
    .Open "alias", "user", "pwd"
  End With
--> time here. COM + half a minute, application 2 seconds for first
connect. AARGH!

Thanks for ANY pointers.

Frank Quednau Received on Mon Jul 23 2001 - 11:56:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US