Hi
I'm looking for the best way to take advantage of the data virtualization capabilities in the GridView control.
I've built a simple test for this using the Northwind database querying the Orders table. I have built using WCF RIA a NorthwindDomainService providing me with an IQueryable<Order>.
I'm requesting the orders for the gridview by:
var data = _northwindContext.GetOrdersQuery();
LoadOperation<Order> loadOrders = _northwindContext.Load( data );
loadOrders.Completed += ( s, e ) =>
{
Orders = ( s as LoadOperation<Order> ).Entities.AsEnumerable();
};
( I have also tried binding the entity set as a List<Order> )
What I am seeing is all 830 records (about 277Kb of data) being served immediately even though only 30 records are on the screen.
Is this correct? Is there a way of streaming the data out so the gridview consumes what it needs?
I know that I could use data paging to solve this issue, but a virtualised display would be a better user experience.
The LOB application I am building will have large datasets and a large number of simultaneous connections.
Thanks
Russell
I'm looking for the best way to take advantage of the data virtualization capabilities in the GridView control.
I've built a simple test for this using the Northwind database querying the Orders table. I have built using WCF RIA a NorthwindDomainService providing me with an IQueryable<Order>.
I'm requesting the orders for the gridview by:
var data = _northwindContext.GetOrdersQuery();
LoadOperation<Order> loadOrders = _northwindContext.Load( data );
loadOrders.Completed += ( s, e ) =>
{
Orders = ( s as LoadOperation<Order> ).Entities.AsEnumerable();
};
( I have also tried binding the entity set as a List<Order> )
What I am seeing is all 830 records (about 277Kb of data) being served immediately even though only 30 records are on the screen.
Is this correct? Is there a way of streaming the data out so the gridview consumes what it needs?
I know that I could use data paging to solve this issue, but a virtualised display would be a better user experience.
The LOB application I am building will have large datasets and a large number of simultaneous connections.
Thanks
Russell
1 Answer, 1 is accepted
0
Hello Russell,
Other possible solution will be to use the grid vertical scrollbar as pager. Please check my blog post for more info.
Regards,
Vlad
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Other possible solution will be to use the grid vertical scrollbar as pager. Please check my blog post for more info.
Regards,
Vlad
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.