Devart Forums

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

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