RE: Slow ODBC connectivity

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 5 Feb 2004 10:07:28 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93697@qtiexch2.qgraph.com>

Stuff keeps coming to mind: Recently we had a single user who could not connect to Oracle via ODBC. It turned out that the wonderful MS IEeeeeeeeee was easily coerced into installing *several* little programs. Aside from making everything networking-wise very slow, the last one somehow prevented the Oracle client from talking to the server!

Just more to check... :)

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Thursday, February 05, 2004 9:53 AM To: oracle-l_at_freelists.org
Subject: RE: Slow ODBC connectivity

Another place to look at is ODBC DataSource parameter called "Preftch Count". By default it is set to 10, which means for the query retrieving 1000 rows ODBC will make 100 trips to the database. Don't be afraid to increase this parameter in DataSource configuration (I have it set to 1000).

Igor Neyman, OCP DBA

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Feb 05 2004 - 10:07:28 CST