TIWDBAdvWebGrid with lot's of records


I'm using FireDAC and I have a TFDquery with lot's of records?
I use a TIWDBAdvWebGrid to display my records? All is ok, except the speed?

Do you have an idea how to use a TIWDBAdvWebGrid with large amount of records, please ?

With best regards,


We are not aware of any issues regarding performance with the TIWDBAdvWebGrid.
Are you using paging?
Can you please specify exactly how many records you are displaying?

Hello Bart,

I've place the property Rowcount to 5 in order not displaying to mutch datas?

If I place the FetchOptions.RecsMax =5 : of course the display for the first 5 records is very fast, after FDquey.open..
If I place the FetchOptions.RecsMax =-1 in order to be abble to navigate into pages, loadding datas is quite long... After loading, speed is normal?

My problem is for the loading datas (FdQuery.open?) that take times?
And I'm wondering how people do when they need to use a TIWDBAdvWebGrid with lot's of records in a query?

Big thank you in advance for any suggestion.
With best regards,

Can you please provide the following information so I can further investigate this?

- The version of Delphi you are using
- The version of IntraWeb you are using
- The name and version of the browser you are using
- A ready to run sample project that demonstrates the issue
Hello Bart,

I've change my code : I've replace the grid by a simple display of a SQL query for one record?
For this time It's OK for me?

I use Delphi enterprise 10.2 with Intraweb 1.45.7 (bundle edition)
I use Chrome?

If I need again a grid, Ill prepare you a sample code?

With Best Regards,