I have a test application that uses databinding to a table of about
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.
The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.
Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.
Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?
20,000 records. The SQL statement for the databinding is "SELECT *
FROM tbl_CID_XRef". From this I can move forward and backward in the
data, edit, add and delete records. It all works fine. There are two
problems.
The first is that it takes awhile for the app to load. The dataset is
filling up with all the records. The second is that the app takes too
much RAM.
Do datasets have a paging feature? Where, for example, I could set it
to a specific size and only that number of records get loaded into the
dataset. Then when moving to a record that is not in that page it will
get the next page.
Or does all this have to be done manually? If so, could you give any
code examples or documentation on this?
Comment