The FetchOptions property has the following sub-properties:
- Mode and RowsetSize: The Mode property allows you to specify how FireDAC should implement the fetching of records for a result set. If you are doing some batch processing or some data transformation involving the whole dataset, you may want to fetch all records in a single shot, to reduce network time (if any, as FireDAC can work both with local and remote databases), especially when the latency is not minimal.
In a perhaps more common scenario for regular applications, you may want the fetching to be incremental to improve the user experience as the user is not forced to wait for the whole dataset to be loaded before starting to see/work with the data. Different values of the Mode property will let you determine the exact behavior of the fetching strategy, ranging from completely manual handling to automatic or semi-automatic. There are a number of secondary aspects involved in fetching...
