Defines whether to request all records of the query from database server when the dataset is being opened.
property FetchAll: boolean default True;
The default value is True.
Note: When setting TCustomMyDataSet.FetchAll = False you should keep in mind that execution of such queries blocks current session. By default MyDAC will create additional session if it is necessary. But this can cause the following problems:
In order to avoid creating additional connection you can set Options to False.