Components for Delphi and C++ Builder.

Hi,

We use the TreeList with the TMemTableEh / TDBGridEh object. It's really powerful and very practical.
With a simple SQL query, we can build our tree by the father / son relationship.

However, for a 4-level tree (level 0 to level 3), and a query returning approximately 3500 rows, the tree build times are quite long (about 7 seconds).
If we disable the TreeList property, it's instantaneous.
Are there any properties that we can disable or a method that we can use to improve this?

I thank you in advance

ISOAR

Hello

Did you try to use the recommendations described in section "Storing records in tree mode (TreeView)" of "EhLib Users Guide.doc"

-----
Adjusting TreeView mode is realized by subproperties of TMemTableEh.TreeList property. TMemTableEh automatically adds new record in the tree, using field values defined by TreeList.KeyFieldName and TreeList.RefParentFieldName properties. When new record is appearances in MemTable, it tries to find Parent record in the list of existing records, it looks throw records trying to find values of the field in KeyFieldName that is equal to the value of the field defined by RefParentFieldName property in the new record. Furthermore, it checks, if this record is a parent for other existing records in array.

Building of tree can be speeding up, if you create indexes for fields specified in TreeList.KeyFieldName and TreeList.RefParentFieldName properties.

However the maximum speed of building tree is possible to achieve if the records all records will be appended in DataSet in valid sequence. In other words every record must be added in DataSet in same order as it appears in the tree. In last case it is not recommended to create indexes, it can only slow down building of tree. If records appear in DataSet in valid order set FullBuildCheck to False. It will not check if the new record have child records in DataSet.
-----

_________________
Best regards
EhLib Support Team

Hi,


It works !!!!

Thank you.