handling huge volume of data in datagrid

6 posts, 0 answers
  1. josephine shirley
    josephine shirley avatar
    10 posts
    Member since:
    Nov 2008

    Posted 23 Mar 2010 Link to this post

    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?
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 23 Mar 2010 Link to this post

    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.

  3. Archieval
    Archieval avatar
    9 posts
    Member since:
    Oct 2020

    Posted 04 Oct in reply to Shinu Link to this post

    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

     

  4. Doncho
    Admin
    Doncho avatar
    72 posts

    Posted 07 Oct Link to this post

    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:

    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

    Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).

  5. Archieval
    Archieval avatar
    9 posts
    Member since:
    Oct 2020

    Posted 21 Oct in reply to Doncho Link to this post

    Hi Sir Doncho thanks for reply,

    I am using telerik for asp.net mvc, is basic and custom paging also available for this?
  6. Doncho
    Admin
    Doncho avatar
    72 posts

    Posted 22 Oct Link to this post

    Hi Archieval,

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

    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

    Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Back to Top