Re: Connection pooling

Modify the registry and change the OLEDB_Services entry for MSDASQL to 0. You should then reboot. Note that by default OLE DB resource pooling is enabled and ODBC connection pooling is inactive.

To verify that ODBC connection pooling is enabled you can check the ODBC counters using PerfMon.

Also, be aware that the version of MDAC you are running can have a significant impact on performance. MDAC 2.1 SP2 or 2.5 both provide good performance.

You may still find that you need to tune Oracle to get it to outperform SQL Server on the same hardware. The default configuration of the Oracle install will only yield mediocre performance.

--
Michael D. Long
http://extremedna.homestead.com


"Newbie" <nospam_at_please.com> wrote in message
news:8h9k5m$j7h$1_at_slb2.atl.mindspring.net...


> I am comparing Oracle 8i and SQL Server 7.0 and am getting poor

 performance


> with Oracle. I have a VB component calling stored procedures in SQL Server

> and Oracle via ADO and ODBC drivers. Oracle is 20 times slower i.e. 0.6

 secs


> per transaction as opposed to 0.03 secs/transaction with SQL Server.

>

> However, if I run the Oracle stored procedure from SQL Plus then I get

 0.002


> secs/transaction. So it looks like the Oracle stored procedure and

 database


> are OK.

>

> I am beginning to suspect that my problem concerns connection pooling. I

 am


> using the Oracle ODBC driver and I wonder if I am not getting any

 connection


> pooling at all. If I have a continuously open conection in VB I get 0.019

> secs/transaction. If I open and close the connection each transaction then

 I


> get my 0.6 secs/transaction figure mentioned earlier.

>

> With SQL Server I'm always closing and re-opening the connection but I bet

> that connection pooling is working and that's why I'm seeing superior

> performance.

>

> So how do I activate connection pooling to my Oracle database? How can I

> tell that it's working?

>

> Thanks in advance.

>

>