jQuery Grid Plugin - jqGrid - Topic: How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets Simple:Press Version 5.7.5.3 TAlex on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22332 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22332 sorry for the duble  post

]]> Mon, 07 Mar 2011 18:32:25 +0200 TAlex on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22331 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22331

tony said:

Hello,

Will see what I can do.

Best Regards

Tony

Hello Tony,

I have the same request of a treegrid example with autoloading tree nodes.

I am trying to do something like this.

- First I load the adjacency grid with the data from an 'url' and 'postData' returned on 'serializeGridData' event.

- OnSelectRow i change with 'setGridParam' the 'url' and the 'postData' and then trigger("reloadGrid")

When I click on the row, the data from the new url overrides the data from the old url so the parent node disapeares.

The order of events is OnSelectRow, then SerializeGridData.

When I click on the text besides the plus icon, the order of events is SerializeGridData then OnSelectRow then loadError.

When I click again on the text besides the plus icon, the order becomes OnSelectRow then SerializeGridData and the childs apear normaly and the parent remains there.

What can I do to get rid of this multi-behaviour?

Can a event like 'subGridRowExpanded' be added to the treeGrid or something similar?

We really need an example of autoloading tree nodes so PLEASE HELPCry

All the best,

Alex

]]> Mon, 07 Mar 2011 18:32:25 +0200 TAlex on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22318 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p22318 Hello Tony,

I have the same request of a treegrid example with autoloading tree nodes.

I am trying to do something like this.

- First I load the adjacency grid with the data from an 'url' and 'postData' returned on 'serializeGridData' event.

- OnSelectRow i change with 'setGridParam' the 'url' and the 'postData' and then trigger("reloadGrid")

When I click on the row, the data from the new url overrides the data from the old url so the parent node disapeares.

The order of events is OnSelectRow, then SerializeGridData.

When I click on the text besides the plus icon, the order of events is SerializeGridData then OnSelectRow then loadError.

When I click again on the text besides the plus icon, the order becomes OnSelectRow then SerializeGridData and the childs apear normaly and the parent remains there.

What can I do to get rid of this multi-behaviour?

Can a event like 'subGridRowExpanded' be added to the treeGrid or something similar?

We really need an example of autoloading tree nodes so PLEASE HELPCry

All the best,

Alex

]]> Fri, 04 Mar 2011 16:36:19 +0200 tony on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14685 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14685 Hello,

Will see what I can do.

Best Regards

Tony

]]> Wed, 10 Feb 2010 15:13:13 +0200 william on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14647 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14647 t loads well when record number is < 200.

If I have around 400 – FireFoxs tells me that script is handing and needs to be stopped.

Reading that there is gridview option for regular grid to speed up, I still hope this will be supported for treegrid too.

Will it? If no, I'd be greatful to hear any solutions or hits on how to speed up the jqGrid with TreeGrid.

-------------------------------------------------

itil training

]]> Tue, 09 Feb 2010 11:41:43 +0200 william on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14646 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14646 t loads well when record number is < 200.

If I have around 400 – FireFoxs tells me that script is handing and needs to be stopped.

Reading that there is gridview option for regular grid to speed up, I still hope this will be supported for treegrid too.

Will it? If no, I'd be greatful to hear any solutions or hits on how to speed up the jqGrid with TreeGrid.

-------------------------------------------------

itil training

]]> Tue, 09 Feb 2010 11:41:40 +0200 Jam on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14614 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14614

I need to load large data in treegrid, too. (about 500 rows)

So I want to use autoloading tree node, but I don't know how to construct that tree.

Please give me some autoloading tree-side sample or method in jquery.

]]> Mon, 08 Feb 2010 06:58:04 +0200 Alex Alexapolsky on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14155 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14155 Thanks for reply, Tony. Indeed, in this case autoloading is the solution.

]]> Fri, 22 Jan 2010 13:26:33 +0200 tony on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14139 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14139 Hello Alex,

This is true. Using large data in tree grid currently is not recommended.

We work on this and hope to resolve the problem.

Also I recommend you to use autoloading tree nodes - i.e first load a minilal nodes (only roots) and then when the user click on some node the data will be loaded from the server. Using this approach pager is not needed. Also pagging with tree nodes is a little bit difficult, since we can have a lot of situations which should be consider.

Best Regards

Tony

]]> Fri, 22 Jan 2010 12:02:04 +0200 Alex Alexapolsky on How to handle tree grid with large data sets? http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14106 TreeGrid http://www.trirand.com/blog/?page_id=393/treegrid/how-to-handle-tree-grid-with-large-data-sets#p14106 I am using jqGrid 3.6.2 with TreeGrid.

It loads well when record number is < 200.

If I have around 400 - FireFoxs tells me that script is handing and needs to be stopped.

Reading that there is gridview option for regular grid to speed up, I still hope this will be supported for treegrid too.

Will it? If no, I'd be greatful to hear any solutions or hits on how to speed up the jqGrid with TreeGrid.

P.S.

Btw, pager would help us divide datasets into smaller chuncks, but documentation says "Pager functionality currently disabled for treeGrid" Frown. The only solution I can think of is to somehow emulate page functionality outside of jqgrid.

]]> Thu, 21 Jan 2010 16:35:41 +0200