It may seem that all of the items from the DataBase are present in the grid, but in reality, only the items of the current page are rendered. Every time the page is changed, RadGrid is sending a request to the server to get the items for the next page specified and then it will do a rebind to refresh the view for the front end, and therefore, it is not possible to change the page without refreshing.
There are several ways that you can optimize the performance. They are described in the Grid Performance Optimizations
and Optimizing Performance - RadGrid
You might also consider using client-side widgets that could be a big improvement. Check out the Kendo UI Grid
to see it in action.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.