Forms 6i - Hierarchical tree item - how to improve performance?

From: Johny <pj_pl_at_yahoo.com>
Date: Thu, 07 Mar 2002 13:21:32 GMT
Message-ID: <3c876885.17761189_at_news.tpi.pl>

I'm loading hierarchical tree item with query. Problem is that it takes long time to load all the items(300, but can be more) to the hierarchical item.
[Quoted] [Quoted] Query takes 0.5 sec., but loading it into the item with Set_Tree_Property(htree, Ftree.RECORD_GROUP takes 3 sec.

code:

[Quoted] PL1 := Create_Group_From_Query('pl1', query); v_ignore := Populate_Group(PL1); -- 0.5 sec Ftree.Set_Tree_Property(htree, Ftree.RECORD_GROUP, PL1); -- 3 sec.

Does anyone have any idea what to do to improve tree loading? Thanks Received on Thu Mar 07 2002 - 14:21:32 CET