From: kennedy-downwithspammersfamily@attbi.net   
      
   "Florin"  wrote in message   
   news:e54ea115.0404280815.3aabc529@posting.google.com...   
   > "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   
      
   Sounds like your connection pooling thing isn't doing its stuff.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)