Skip to main content

Notifications

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

Difference in response time when filtering a list by a field with a list of values with DBC Release 21.x on premises

Posted on by 10

Hi there

we have a page in DBC Version: CH Business Central 21.2 (Platform 21.0.49939.49984 + Application 21.2.49946.49990)

on prem with windows server 2019  where you can filter a list of customers by different fields.

When we put a filter on the customerid field an then put in a customer number in this field and then leave the field with the tab key it takes around 5 - 7 sec. till the specific customer is 

displayed as a row in the list on the page.

Here comes the strange thing:

When we use a customerid which we have previously copied from a text or excel file and copy that in the customerid field and leave the field immediately with the tab key it

takes a blink of an eye and the line is displayed.

I was wondering why there is that difference in the performance and what could be done to have that blink of an eye performance also when just typing in the customerid.

We had before severe performance issues with the customer data because apparently there is this partila records functionality Partial Records - Business Central | Microsoft Learn which according ms only

was working from Release 21.x on.

I'm looking forward to any hints or suggestions you might have.

Thanks.

Cheers quebonito 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans