Re: Performance problem using oracle and ado

Hey Roderick

Using DAO (Jet) or MS Query you get back a snapshot recordset This is the ODBC Direct query to server.

The ODBC Direct query is the fastest type of query from DAO, ADO or RDO environment.

I think that you should see what type of cursor you are asking from server at your project.

And I also think that it is no big difference between types of providers you use at project (MSDAORA or ODBC=DSN) for make connection to Oracle.

As far as I know in some situations (for some queries) OLE DB for Oracle is faster then
ODBC provider, but some times the second is.

One more question here.

How do you think, how many rows you have got to client machine using MS Query when you have seen a result into a grid ? I think that there were not all 2500 rows, but only first 300-500 (it is like a cache).

When you go down then tool takes more 300-500 rows into the grid and so on. If say about VB grid, you get all 2500 rows into and then this grid is shown.

As you understand it takes more time to get all 2500 rows to client at one time
in comparison with the first way.

Regards !

Igor Faershtein Received on Mon Jun 07 1999 - 00:14:18 CDT