Unidac 6.3.13, oracle, fetchall

[albourgz]

Hi,

c++ builder XE10 Seattlen unidac 6.3.13

I have a TUniQuery

Code: Select all

SELECT b.*, c.*
FROM VBILLS b, VClients c where b.customer=c.id 
 AND b.FACTDATE >=TO_DATE('2016-05-15', 'yyyy-mm-dd')
ORDER BY b.ID DESC

When run in sql*developer, first rows come within the second, ctrl-end (read all rows) takes 2 seconds.
Using odac (oracle 12c direct mode): it takes 22 seconds, even if FetchRows=25 and Oracle.FetchAll=false in TUniQuery.SpecificOptions?

Is it normal that even if fetchall is false, the query takes the same time than returning all rows? And that it takes 8 times more time than in sql developer?

KR.

[AlexP]

Hello,

Please check this behavior with Oracle client. In addition, send us the scripts for creating tables and the number of rows in tables.

[albourgz]

OK. Works fine using Oracle Client.
Sending scripts by e-mail.

[AlexP]

Thank you. We have received your sample. We will try to respond as soon as possible.