Speed difference between TOracleDataSet and PL/SQL developer

[Jariten]

Hi,

I have a TOracleDataSet with a select statement.

Cutting and pasting this statement into PL/SQL developer, and changing the only bind variable to a value, the first 100 records are returned in 0.6 odd seconds.

at runtime, opening the TOracleDataSet takes 5-6 seconds before the OnAfterOpen event is called.

It is not the first query in the application to be run by this point.

What am I doing wrong!

Versions
Delphi 6
DOA 3.4.5.1
Oracle 9i

Thanks for any insight

Alex

 

[Eric^2]

PL/SQL developer stopps returning rows after it hits the limit (i.e. your 100 rows). The Dataset loads all rows before firing the event.

1) How many rows is the Dataset returning?
2) Can you use a threaded query in place of the Dataset?
3) Try limiting the number of rows returned with a WHERE clause.
4) You may look at using WHERE ROWNUM < 100.