Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> An astonishingly slow DB opening
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
![]() |
![]() |