Grouping and pagination in grids

[rolf.woll]

Hi,

SmartGwt Power build 2040803

As far as I understand, grouping in ListGrids require the client to retrieve all data from the server.

This is fine. However, when testing this, it appears as if the grid is retrieving the server data in page sizes of 75.

Is there any way to make the grid retrieve all data in one single fetch when grouping while keeping the page size of 75 for ordinary fetches?

Regards
Rolf

[Blama]

Hallo Rolf,

did you already see ListGrid.setGroupByMaxRecords()?

Best regards,
Blama

[rolf.woll]

Hi Blama,

Thanks for your reply.

Yes, I have seen that setting. I believe that is used to disable grouping for datasources over a given set of records for performance reasons.

In my case, grouping is available, since I have set groupByMaxRecords above the number of records in the database. However, when the client fetches the data from the server it does so in pages of 75 records, which is inefficient since all records should be retrieved anyhow.

Regards
Rolf

[Blama]

Hi Rolf,

please see my bug report about a (unrelated) bug using grouping. It clearly shows that this setting is/was used as expected in the requests. I did not retest, though.

Best regards,
Blama

[rolf.woll]

Hi Blama,

Thanks for the reply and the link. I will look into it.

However, I think the problem in my case was that I have progressive loading enabled for the datasource.
Once I removed the progressive loading setting, the grouping was performed with one fetch as expected.

Regards
Rolf