Why do all the references to data paging seem to apply only to the ASP.NET
environment ? Surely data paging is an issue on rich client windows forms as
well ?
Let us suppose I have a database of 100,000 employee records in a database,
each containing 100 fields of data, and a client screen that allows these to
be queried in a grid. Given that some users may want to issue an open query
to view ALL employees, do I really have to fetch all 100,000 records in full
? I'm sure the answer is no, but I can find no guidelines on how to fetch
the data in batches (pages) as required (eg. only as the user scrolls down
the grid and exposes some employees not yet fetched).
This gets more complicated when you consider that the user may then want to
order by any of the columns by clicking on the column heading. Theoretically
this may mean that you have to clear your data and start fetching in batches
again.
Has anyone tackled this issue ? Does anyone have any guidelines ?