handling huge volume of data in datagrid

[josephine shirley]

Hi

We are having a situation in which the grid is binded to millions of rows and we can’t afford network traffic to pull all the data and  then filter.

So I would like to know Is there any way  in telerik radgrid to handle filter the data server side using stored procedures instead of pulling all the data and filtering in the client side?

[Shinu]

Hello,

One suggestion to increase performance when you have large number of records, is by using custom paging which will retrieve only fixed set of records at a time.

Also checkout the documentation for more information on optimizing performance of grid. Hope this helps.

Client/server grid performance optimizations

 

-Shinu.

[Archieval]

Hi Shinu's, this is exactly what i needed, do you have example on how i can achieve this? i used telerik grid and i want to read 10 records per page that i no need to read first all the records

 

[Doncho]

Hi Archieval,

You can find samples of Basic and Custom Paging in our live demos. You can also review the implementation in the code section below the demos:

• Custom Paging
• Basic Paging

More information about the paging functionality of RadGrid you can find in the Paging section in our documentation, see Custom Paging

Please let me know if you need any additional information!

Kind regards,
Doncho
Progress Telerik

[Archieval]

Hi Sir Doncho thanks for reply,

I am using telerik for asp.net mvc, is basic and custom paging also available for this?

[Doncho]

Hi Archieval,

You can find details about the paging functionality of the Grid component from the Telerik UI for MVC in the following resources:

• Grid | Paging
• Paging - demo
• Pager Functionality

In case you have further questions related to the Grid component for MVC, please feel free to raise them in the UI for ASP.NET MVC Forum, or open a formal support ticket for the product you are using.

Kind regards,
Doncho
Progress Telerik