Hello good afternoon, I have a question regarding the DataSet ...
if my Products table has 1 million records, and my pagination has to display only 10 records, my query in the database will return 1 million records at once or it will fetch + 10 records each time I change pages ?
Would it be better for me to work on the pagination at the time of my consultation?
var
GridPlugins: TGridPlugin;
begin
GridPlugins := TGridPlugin.Create(tcProduto, dsProdutos, lcProduto, lblProduto);
GridPlugins.SetPageSize(10);
GridPlugins.Load;
end;