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

From: Gabriele Lamon <g.lamon_at_mcg-econ.it>
Date: Fri, 8 Mar 2002 10:18:19 +0100
Message-ID: <a69vme$rgv$1_at_fe1.cs.interbusiness.it>


> Query takes 0.5 sec., but loading it into the item with
> Set_Tree_Property(htree, Ftree.RECORD_GROUP takes 3 sec.
Try to put the query directly in the Tree

> code:
>
> 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.

Ftree.Set_Tree_Property(htree, Ftree.QUERY_TEXT, query); -- 3 sec.

Ni hao, Lelle. Received on Fri Mar 08 2002 - 10:18:19 CET

Original text of this message