da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: ADQuery RowsetSize

Forum List » AnyDAC » v 1.x General English

rofoeagle
User

Fresh Boarder

Posts: 1

Karma: 0

ADQuery RowsetSize

Posted: 2007/12/06 09:20

About ADQuery is there any way to set automatically the RowsetSize?

I mean default is FetchOptions.RowsetSize = 50, however if I do a query of 500 records, only show 50.

I can change the value manually but for example I set the FetchOptions.RowsetSize = 10000000 for avoid limitation, however it seems that my application got very slow and sometimes show me an "low memory" alert.

Is there any way to set automatically the rowset acording with the recordCount

Diman

Admin

Posts: 1470

Karma: 18

Re:ADQuery RowsetSize

Posted: 2007/12/06 18:02

Hello

You misunderstood RowsetSize.

RowsetSize is the number of rows, which AnyDAC will fetch at each fetch operation. It is not the total number of rows in result set. ADQuery will automatically fetch rows, when application scrolls down in dataset, by RowsetSize at each next fetch. So, if there is 170 rows, then ADQuery will fetch 50+50+50+20 rows.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English