24.285 Dataset into a Gridpanel Very Slow Loading! Please help

  1. #1

    24.285 Dataset into a Gridpanel Very Slow Loading! Please help

    I tried to load 24.285 into a gridpanel , but the load time is very slow
    I read the examples about paging , but i can't paginating the dataset information , please is a very important detail
    in my project , i need help

    this is the load method
    
    Public Sub mostrarEntidades()
            Try
                Dim objEntidad As New ENTIDAD
    
    
                With StoreEntidad
                    .DataSource = objEntidad.Consultar ' this return a dataset with the 24.285 information
                    .DataBind()
    
                End With
                Window1.Show()
            Catch ex As Exception
    
            End Try
    
        End Sub
    <ext:Store ID="StoreEntidad" AutoLoad="false"  runat="server">
        <AutoLoadParams>
                            <ext:Parameter Name="start" Value="={0}" />
                            <ext:Parameter Name="limit" Value="={10}" />
                        </AutoLoadParams>
        <Reader>
        <ext:JsonReader>
        <Fields>
        <ext:RecordField Name="id"></ext:RecordField>
        <ext:RecordField Name="rut"></ext:RecordField>
        <ext:RecordField Name="nombre"></ext:RecordField>
        <ext:RecordField Name="mail"></ext:RecordField>
        <ext:RecordField Name="nombreComuna"></ext:RecordField>
        <ext:RecordField Name="dv"></ext:RecordField>
        
        </Fields>
        </ext:JsonReader>
        
        </Reader>
        </ext:Store>
  2. #2
    Hi,

    Loading 24,285 records into a Store is not going to work. You need to provide server-side paging.

    I'd recommend pushing no more than 100 records at a time down to the client. Of course, that's only guideline. Depending on your scenario and size of each records, you might need to return less records, or you might be able to return more records.

    Another option if you're using Ext.NET v2 is Infinite Scrolling, see

    https://examples2.ext.net/#/GridPane...ling/Overview/

    Although, even Infinite Scrolling isn't a great solution for 20,000+ records. Server-side Paging, Sorting and Filtering is what you should be doing.
    Geoffrey McGill
    Founder
  3. #3
    Quote Originally Posted by geoffrey.mcgill View Post
    Hi,

    Loading 24,285 records into a Store is not going to work. You need to provide server-side paging.

    I'd recommend pushing no more than 100 records at a time down to the client. Of course, that's only guideline. Depending on your scenario and size of each records, you might need to return less records, or you might be able to return more records.

    Another option if you're using Ext.NET v2 is Infinite Scrolling, see

    https://examples2.ext.net/#/GridPane...ling/Overview/

    Although, even Infinite Scrolling isn't a great solution for 20,000+ records. Server-side Paging, Sorting and Filtering is what you should be doing.
    Geoffrey,

    It would be great if we get some sample which describes how to do server side, filtering/sorting.
  4. #4

Similar Threads

  1. Page Loading very very slow
    By vs.mukesh in forum 1.x Help
    Replies: 8
    Last Post: Sep 24, 2012, 7:15 AM
  2. [CLOSED] Slow loading of image from browser cache
    By nhg_itd in forum 1.x Legacy Premium Help
    Replies: 3
    Last Post: Jun 06, 2012, 11:52 AM
  3. Replies: 7
    Last Post: Jun 03, 2011, 9:18 PM
  4. Page Loading very slow
    By Rupesh in forum 1.x Help
    Replies: 0
    Last Post: Mar 25, 2011, 5:26 AM
  5. Replies: 2
    Last Post: Aug 18, 2009, 11:22 AM

Tags for this Thread

Posting Permissions