Tree view list and performance issue

(7) Share

Report

Posted on by RahulShah

111

We are planning to use tree list view for one of the custom forms that we are building.

There can be hundreds of records and to be grouped dynamically say based on the 'Quantity' and several other grouping criteria.

Two questions

- Is this possible to achieve - i.e. building dynamic grouping constructing the tree view list?

- Would it cause performance issues later with 300 to 400 records at a time and with just two levels of tree?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (4)

Report

I have yet to see a performance issue with the "Structure" (aka Tree View) capability within Business Central. 300 to 400 records and only two levels is not a heavy lift for the system. Be sure you have Dynamic Low-Level Code turned on, and you should run the Calculate Low-Level code function if it wasn't already turned on.

The system will show you the base structure (as if you were making 1 Finished Good). If you want to see the breakdown with costs, you will use the Cost Shares report.

Hope this helps!

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Verified answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

The number of records would not slow down the system, at least not significantly. It would be important to have the data well prepared and only two levels. The best practice would always be to prepare the data before displaying it.

I hope this helps.

Regards,

Andrés

Was this reply helpful? Yes No
RahulShah 111 on at

Like (1)

Report

Andres and Ben,

Thank you for input and clarification on the performance issue.

We realized that in our case, the back end data structure does not allow to construct the tree directly as data is coming from the multiple table.

This may necessitates the need for introducing the temporary table.

Do you see performance getting impacted due to this?

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi

I don't think it will have much more impact on performance, focus on using SetLoadFields and having the TreeInitialState property set to CollapseAll

Best

Gr

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, If you are concerned, you can import some GL Accounts and then check in the Chart of Accounts Overview (634, List) to see if there are any performance issues.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
RahulShah 111 on at

Like (2)

Report

Thank you all for your input and suggestions.

Really appreciated you taking time and sharing this valuable information.

I am convinced to go ahead build the tree for our requirement without much worrying about the performance.

I will share my experience with the tree after some time on this thread.

Was this reply helpful? Yes No