Livebindings and pagination

[NIRAV KAKU 0]

Has anyone noticed that pagination doesn't really work with livebindings? If you use LB, the app will end up fetching all records anyway. 😕

[Brian Warner 0]

Yes.  Delphi 12.1, FireMonkey, Win11 64-bit, compiling for Win64 platform.

 

I have one table with 1.2M+ records. Using a TFDConnection and TFDTable to access it and a BindSourceDB component.DataSet the TFDTable. 

At design time, when I set TFDTable.Acitve = True, it takes < 1 sec to acknowledge the request. If only a TEdit is involved, then at run-time things

are very fast.  Try to display the table in a TStringGrid and run, it takes several minutes, and the task manager shows more than 1.2 GB before one 

of several error messages appears. 

 

I have the fetch options for both the TFDConnection and TFDTable to Rowset Size = 50 and the TStringGrid.Rowcount = 50.  I've attached a screen 

shot to try to clarify the setup.

 

I should note that if the program eventually displays, using the vertical scroll bar thumb allows very fast scrolling from the top of the table to the

bottom. However, if I click the First or Last button on the navigator, it can take 10 seconds to go the top or bottom of the table.

 

Clear Skies

Brian D. Warner