For optimum performance, grid.PageMode should be set to true. Depending on the TDataSet used, it might further improve performance to implement the OnGetRecordCount event.

The grid supports internal sorting, filtering, grouping, lookupbar as opposed to sorting, filtering, grouping performed on dataset level. When it is preferred to use the grids internal implementation as opposed to the dataset level implementation, set grid.PageMode = false.

Features like disjunct row selection, rearranging data (with goRowMoving = true in grid.Options or via drag & drop) also require that grid.PageMode = false