Page 1 of 1

OnFetchNewRows Event?

Posted: Tue 01 May 2018 13:18
by JensFudge
Hi,

I am trying to optimize an application where at some customers data handling takes 4 times as much time as with others.
I have set on a TUniQuery:

SpecificOptions.Values['FetchAll'] := 'false';
FetchRows := 1000;
UniDirectional := true;

Upon opening the query with qry.open; it takes 1 second at most customers, and 75 seconds at other customers.
The internal handling of the many records takes around 15 minutes, but at the slow customers it takes an hour.
I am worried that setting FetchAll to 1000 will have the impact that for every 1000 rows it will take far too long.

Is there a way I can check when it actually fetches more rows?

Like an OnFetchNewRows event

Thanks in advance

Kind Regards
Jens Fudge

Re: OnFetchNewRows Event?

Posted: Wed 02 May 2018 08:21
by azyk
Use the BeforeFetch event handler to know the moment when the block of records is fetched from the server. More details about this in our online documentation:
https://www.devart.com/unidac/docs/deva ... efetch.htm