OnFetchNewRows Event?
Posted: Tue 01 May 2018 13:18
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
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