From: fvanbortel@netscape.net   
      
   Florin wrote:   
      
   > "Jim Kennedy"  wrote in message   
   news:...   
   >   
   >>"Florin"  wrote in message   
   >>news:e54ea115.0404271844.73035739@posting.google.com...   
   >>   
   >>>Hi,   
   >>>   
   >>>I am experiencing some problems accessing an Oracle database through   
   >>>OLE DB from an MTS application using OpenWithServiceComponents (which   
   >>>is supposed to give me connection pooling).   
   >>>When I connect to a SQL Server database it only takes 3.1 ms to open a   
   >>>connection, while with Oracle it takes 15.5 ms (both DB's running on   
   >>>the same machine).   
   >>>Am I doing something wrong, am I missing something here?   
   >>>I have tried to use the plain Open method, but in this case it takes   
   >>>5.4 ms with SQL Server and 31.4 ms with Oracle.   
   >>>Is Oracle really that much slower when accessing it through OLE DB?   
   >>>   
   >>>Thanks for any advice/hints!   
   >>>Florin   
   >>   
   >>What about subsequent times?  Is the machine (server) swapping?  MS   
   >>SqlServer is known to take all the ram on the machine and that could do it.   
   >>(try shuting down the instance and see if it makes a difference).  It is   
   >>hard to say since you are going through a lot of non-native stuff.  So who   
   >>knows what it is doing.   
   >>Jim   
   >   
   >   
   > What I did was to open and close the connection 1000 times and take   
   > the average response time for this operation. No DB queries were   
   > involved. I have 1 GB RAM, there is also no swapping involved. It just   
   > seems that the connection pooling is still much slower in Oracle than   
   > in SQL Server (about 5 times) and I would like to know why...   
   >   
   > Florin   
   Use IPC (or even better BEQ) stack instead of TCP/IP.   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)