TIWDBAdvWebGrid with lot's of records

herve_le_peuvedic · May 28, 2018, 12:40pm

Hello,

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,

Herv? LE PEUVEDIC

Bart · May 28, 2018, 4:50pm

Hi,

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?

herve_le_peuvedic · May 29, 2018, 11:23am

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,

Herv?

Bart · May 30, 2018, 3:59pm

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

herve_le_peuvedic · June 4, 2018, 10:33am

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,

Herv?