Performance problem using oracle and ado

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 - 13:22:27 CDT