Re: Performance problem using oracle and ado

From: Timothy Q. Oliver <timothyoliver_at_netscape.net>
Date: Sun, 06 Jun 1999 23:00:32 -0400
Message-ID: <375B35CF.7BD498BC@netscape.net>

Roderick,

The problems you are experiencing are unusual to be sure. ADO performance is supposed to be both quicker and easier to program than Jet. I use Oracle 8 and ADO and retrieve four times as many rows as what you describe in about two seconds or so. My Oracle server is on a Solaris box with over 1GB or RAM. A couple of tuning tips you might try is:

1) If possible: setting your recordset to adopenforwardonly
2) If possible: setting your recordset to adLockReadOnly
3) Make sure your connect string is the same everytime you access the

database. That means the same userid/password, provider, etc. 4) Make sure you are using the Provider=MSDAORA and not ODBC=DSN... 5) Make sure you are only asking for the columns you will need at one time.

Keep in mind that it is not likely since your Jet queries are performing acceptably but your database server may need tuning as well.

Hope this helps!!

Roderick De Vera wrote:

> Help please!
>
> Forgive me if this is a no brainer question.
>
> I am trying to retrieve approx 2500 rows in my VB6 program from an
> average size table in Oracle via ADO and I am experiencing an
> unacceptable performance. The approximate time elapsed to retrieve the
> recordset is about 6 seconds compare to using RDO it returns right away.
>
> Trying it on a third party tools such as the MS Query and Data tools
> which I assume uses ADO it is quick (fraction of a second).
>
> Is this the normal behavior of ADO considering the number of rows I am
> requesting? Is there something I am missing?
>
> By the way, i am using Oracle ODBC Driver 8.01.05 and ADO 2.1
>
> I really need help
>
> Thanks
>
> Rod
Received on Sun Jun 06 1999 - 22:00:32 CDT