Out of memory with thousands of datarows with RadGridView and OData

[Vitaly]

Hello.

I have RadGridView with Source bound to QueryableDataServiceCollectionView that looks at OData services.

I have paging by 100 by default. And it normally works with filtering and sorting.

By when I run into grouping.. it goes wrong.

I see only first group on page and i can reach next group turning the page many times.

As I see applying the group involves data request with sorting by name of grouped column.

So I get 100 of 1000 first rows of first group and in result I get only one group on page and i must turn the page 10 times to reach next group.

When I collapse first group i certainly dont see others.

How to solve it and see all the groups?