Defines whether to request all records of the query from database server when the dataset is being opened.
property FetchAll: boolean;
When set to True, all records of the query are requested from database server when the dataset is being opened. When set to False, records are retrieved when a data-aware component or a program requests it. If a query can return a lot of records, set this property to False if initial response time is important.
Opening a dataset in FetchAll = False mode requires an active transaction.When the FetchAll property is False, the first call to TMemDataSet.Locate and TMemDataSet.LocateEx methods may take a lot of time to retrieve additional records to the client side.