title: FireDac Polling records on demand and show them in StringGrid
body: <p>I am using Delphi 10 Seattle, FireDac, Oracle Database and the TMS Components.</p>
  
  <p>I am looking for a method that allows me to load data from my dataset/query and put it on a <code>StringGrid</code> on demand. I think the correct expression would be <code>paging</code>.</p>
  
  <p>When i have a huge number of records (5000+) my application is freezing (~5s) till it loads all of them in the grid.</p>
  
  <p>I've read the wiki post from Embarcadero about <a href="http://docwiki.embarcadero.com/RADStudio/XE8/en/Fetching_Rows_%28FireDAC%29" rel="nofollow">Fetching Rows</a> but i didn't find a solution there.</p>
  
  <p>I tried different combinations of the TFDQuery <code>FetchOptions</code> and <code>ResourceOptions</code> but without luck.</p>
  
  <p>I noticed that the SQLDeveloper by Oracle performs exactly how i want my application to behave.</p>
  
  <p>I've recorded this short clip to demonstrate how the SQLDeveloper loads massive amounds of records:
  <a href="https://gfycat.com/BlankOrganicIndianpalmsquirrel" rel="nofollow">https://gfycat.com/BlankOrganicIndianpalmsquirrel</a></p>
  
  <p>It first loads 50 records and as I scroll through the grid the other records get loaded.</p>
  
  <p>So the question is how can i get the same polling technique like SQLDeveloper. 
  Thanks!</p>
  
  <p>EDIT: Was using LiveBindings. Switched to db-aware components and it looks fast as lightning now.</p>