pagination in dataset

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?

  GridPlugins: TGridPlugin;
  GridPlugins := TGridPlugin.Create(tcProduto, dsProdutos, lcProduto, lblProduto);

I suggest indeed to use a mechanism that your TWebClientConnection performs a HTTP request to get only a page of data in the TWebClientDataSet at a time.