Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance problem using oracle and ado

Re: Performance problem using oracle and ado

From: <bonanos_at_yahoo.com>
Date: Tue, 08 Jun 1999 10:25:42 GMT
Message-ID: <7jir32$hd9$1@nnrp1.deja.com>


Hi

> 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?

The probable problem is that you are retrieving all the rows into your VB app.

Make sure you are not using things like findfirst or vb specific methods,functions that would cause all the data to be retrieved in one go.

I suggest you test the connection in its simplest form first, link a table to datagrid, then try it with a select statement (in the query), then try any VB recordset type operation.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 05:25:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US