Small and medium business | Business Central, N...

Business Central Performance Issue

(0) Share

Report

Posted on by MD365Developer

Hi,

We are facing the issue regarding extremely slow list scrolling, movements between cards and cards opening. The biggest problem is the customer table. This table has customizations - 10 extensions are published on this table. There are around 30 new fields added to this table, divided in 10 extensions in order to group logic parts of the process. Everything seemed to be fine until the client's data was imported. There are over 40000 records in the customer table. After data import managing customer data become extremely slow.

We did some testing with this number of records and 4th extension that is published on customer table is causing the issue. When 3 extensions are published (regardless of the number of the fields in each - testing was done with one field in each extension), everything is working fine. Fourth is blocking the process.

Does anyone have an idea what can be the reason for this and how can this be overcome?

BC version is 13.7.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report

are some of the new fields flowfields?

if its on premise, work with tools like sql profiler to find long running statements, also check windows eventlog.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

When you create table extension, you basically create a new table in the background. When you open the table, BC will join that table with its table extension.

If you have 10 table extensions, you will have 10 joins which decrease your performance.

You can try combining the table extensions into one in a separate app.

Was this reply helpful? Yes No
MD365Developer 5 on at

Like (0)

Report

No, there are no flowfields in extensions. We checked profiler but it is returning issues with standard join queries and we do not see how this can be overcome since there are new tables for each extension on SQL. Standard and additional tables must be joined in order to display the whole list in the client.

Thanks for suggestion.

Was this reply helpful? Yes No
MD365Developer 5 on at

Like (0)

Report

Yes, we are aware of that fact. Combining extensions now will be complicated since all the data stored in extension fields will be deleted in the process. We are trying to find a way to avoid this.

It seems now that BC is limited to the number of extensions on the table, which is really strange, and we were not aware of that.

Thank you for suggesting.

Was this reply helpful? Yes No
Alexey Finogenov 1,659 on at

Like (0)

Report

useful link: Performance Overview

Table extension impact on performance

Was this reply helpful? Yes No
MD365Developer 5 on at

Like (0)

Report

Yes, this is useful, thank you.

Was this reply helpful? Yes No