OnFetchNewRows Event?

[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

[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