[CLOSED] OutOfMemoryException when binding gridpanel to datatable with +/- 100000 rows

  1. #1

    [CLOSED] OutOfMemoryException when binding gridpanel to datatable with +/- 100000 rows

    I'm getting an OutOfMemoryException in Resourcemanager.cs, line 764 when binding a gridpanel to a datatable with +/- 100000 rows. I use paging.
    Last edited by Daniil; Dec 02, 2010 at 8:52 AM. Reason: [CLOSED]
  2. #2
    Hi,

    You are binding approx 99900 too many rows. Reduce your dataset.
    Geoffrey McGill
    Founder
  3. #3
    Is there a maximum size you recommend for using with gridpanel? You said i'm binding approx 99900 too many rows, so the maximum size you recommend is only 100 rows?
  4. #4
    Hi,

    Just imagine that you try to serialize to json format 100 000 rows. Browser and javascript engine are not designed to display such amount of data. Even if we can serialize 100 000 rows then browser can hang up while handling the data because javascript is one threading enviroment (page is inaccessable while javascript code is executed).

    The best solution to use remote paging and display small portion of the data per time (aprx 100 rows per grid page)
    https://examples1.ext.net/#/GridPane..._Sorting/Page/
    https://examples1.ext.net/#/GridPane...rting/Handler/
    https://examples1.ext.net/#/GridPane...ON_WebService/
    http://ext-net.blogspot.com/2010/11/...nst-large.html
    Vladimir Shcheglov
    Sr. Developer

Similar Threads

  1. [CLOSED] Rows empty grid using DataTable.
    By stoque in forum 1.x Legacy Premium Help
    Replies: 6
    Last Post: Jun 13, 2011, 10:19 PM
  2. How to solve the OutOfMemoryException
    By Dig2010 in forum 1.x Help
    Replies: 9
    Last Post: Dec 15, 2010, 4:31 PM
  3. [CLOSED] Binding Store to Datatable VERY slow...
    By iansriley in forum 1.x Legacy Premium Help
    Replies: 7
    Last Post: Oct 28, 2010, 1:57 PM
  4. Binding GridPanel's rows dinamcally
    By cocci in forum 1.x Help
    Replies: 0
    Last Post: Nov 24, 2009, 12:31 PM
  5. Replies: 6
    Last Post: Dec 20, 2008, 5:35 AM

Tags for this Thread

Posting Permissions