master column tree - bad performance

[Ronib]

Hello,

I have a table with master column that uses recursive node without Load Children event. the whole table loads at startup. I Have very bad performance : every click on the little triangle takes about 6-7 seconds, and there is even no round-trip to server because all data is already at the client!

I need to show list of products by there family (50 families, each has 10 products). How can i imporve my performance (maybe server configuration or my code or another method)

I work with ep 7 sp12.

Thanks

Roni.

[former_member365727 · Accepted solution]

Hi,

Its better to go with the code, use onLoadChildren event. Only when you expand the tree onLoadChildren event will be triggered and the corresponding nodes will be loaded.

In this scenario the entire tree will not be loaded at single instance, only the top node will be loaded and when the event(onLoadChildren) is used at runtime rendering will be done. This improves the performance.

Regards

Srikanth

[Ronib · Accepted solution]

Dear Srikanth ,

but then on every click on the family node , i would have to manipulate my table to display the products rows (add element on the right place).

is it better than loading it once on startup?

what are the limitations of that ui control ?

is it better to create more levels on the tree or stay with 2 levels?

Roni

[former_member365727 · Accepted solution]

Hi Roni,

Yes, you have to manipulate the add element on before loading the tree. Best Practice is to use onLoadChildren event. Loading the tree at once will always have performance issues.

Refer to these tutorial for creating tree using onLoadChildren event.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webdynpro/wd%20java/wd%20tutorials/constructing%20a%20recursive%20and%20loadable%20web%20dynpro%20tree.pdf">Recursive Loadable Tree</a>

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webdynpro/wd%20java/wd%20tutorials/integration%20of%20a%20tree%20structure%20in%20a%20web%20dynpro%20table.pdf">Integration of Tree Structure in Table</a>

There are no limitations on this UI control, you can stay with any number of levels.

Regards

Srikanth