This is my scenario
I have GridView ang DataPager on my Page. I use QueryableCollectionView to get the data and bind it to my DataPager then linked to my GridView.
I have 50000 records. I noticed that when I load the page, It takes few seconds before the page actually displays. The window hangs. Using IsBusy to the GridView doesnt help as it does not show completely (No loading indication)
when I debug the code I noticed that on my ViewModel, this part of the code takes the few seconds to get the data.
Account = new QueryableCollectionView(accounts.OrderBy(o => o.ID));
This returns 10 records only as my DataPager is set to PageSize="10" which is expected. but the loading time take long.
Any Help/Idea to prevent the window from hanging and use the IsBusy property while loading the data on the grid?