Unidac 6.3.13, oracle, fetchall
Posted: Tue 16 Aug 2016 07:01
Hi,
c++ builder XE10 Seattlen unidac 6.3.13
I have a TUniQuery
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.
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
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.