Results 1 to 3 of 3

Thread: Grouping and sorting huge quantity of data in grid

  1. #1
    Sencha User
    Join Date
    Jan 2016
    Posts
    2

    Default Grouping and sorting huge quantity of data in grid

    Hi, i've a grid where i display some rows based on user filter, about 40.000 rows maximum (this is the worst case, but possible).


    I'm working with Extjs + Asp.NET, so JSON store. I know that i can use paging, but i need the grouping (and sorting) funtionality of the grid. Grouping on single page has no sense, i've tried also with infinite scrollbar but the problems persists.


    I've seen that grid's rendering, also with 20.000 rows is not so bad, the problem is that in this case the JSONResult passed by Asp.NET to javascript is very huge (about 15 MB and i've reduced at least length of description fields).


    So my questions are:
    - Can i ZIP in asp.net the json result and decompress in javascript?
    - Any other suggestions about managing so many data keeping grid's grouping and sorting funtionality?


    Thanks in advance.

  2. #2
    Sencha Premium Member richardvd's Avatar
    Join Date
    Jun 2011
    Location
    NL
    Posts
    255
    Answers
    22

    Default

    Enable HTTP compression in your web server. The browser will decompress automatically without any change in your Javascript.

    I have no experience with ASP.NET but this Google result may be helpful:
    http://stackoverflow.com/questions/2...c-with-iis-7-5

  3. #3
    Sencha User
    Join Date
    Jan 2016
    Posts
    2

    Default

    Quote Originally Posted by mto89 View Post
    Hi, i've a grid where i display some rows based on user filter, about 40.000 rows maximum (this is the worst case, but possible).


    I'm working with Extjs + Asp.NET, so JSON store. I know that i can use paging, but i need the grouping (and sorting) funtionality of the grid. Grouping on single page has no sense, i've tried also with infinite scrollbar but the problems persists.


    I've seen that grid's rendering, also with 20.000 rows is not so bad, the problem is that in this case the JSONResult passed by Asp.NET to javascript is very huge (about 15 MB and i've reduced at least length of description fields).


    So my questions are:
    - Can i ZIP in asp.net the json result and decompress in javascript?
    - Any other suggestions about managing so many data keeping grid's grouping and sorting funtionality?


    Thanks in advance.

    There is no way to do this compressing data of json result in asp net and decompression in javascript without change iis configuration?

Similar Threads

  1. How to get the group quantity of store data?
    By bnuy1y2 in forum Ext: Discussion
    Replies: 2
    Last Post: 17 Jan 2012, 9:56 PM
  2. Huge Grids: Paging and Grouping
    By necco in forum Ext 3.x: Help & Discussion
    Replies: 4
    Last Post: 2 Apr 2011, 9:51 AM
  3. Grid grouping and sorting
    By extjs1111_user in forum Ext 3.x: Help & Discussion
    Replies: 6
    Last Post: 5 Oct 2010, 9:39 AM
  4. ExtJS grid , huge data problem
    By jankshtt in forum Ext 2.x: Help & Discussion
    Replies: 1
    Last Post: 22 Sep 2009, 2:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •