Slow TDBAdvGrid.DataSource assignment

VCL TMS VCL UI Pack
1
When I assign a DataSource with 1000000 entries to a TDBAdvGrid, it takes up to about 20 seconds to display.
With a TDBGrid, it only takes half a second.

PageMode is true
DataSetType is set to dtNonSequenced

What else can I do to speed things up?

Thanks, Sven
2

Hi, have you tried to set the OnGetRecordCount Event - otherwise the grid set the recordcount by moving from first to the last row.

for me this helps!
Regards, Thomas