Web Client Field Dropdown Slow

Cyberghost
Cyberghost Member Posts: 46
in NAV Three Tier
We had a customer go live recently with NAV 2018 CU7 using the Web Client.

Generally all is good but when on, for example, a sales order and they start typing into the Customer No., it is very slow to show the list.

We've noticed that the SQL for getting this not only gets the fields specified in the DropDown Field Group but also all of the standard fields and all of the fields in any extensions (of which there are a few).

Has anyone else had this issue and does anyone know of any ways to speed this up?

Thanks

Chris
"When you eliminate the impossible, whatever remains, however improbable, must be the truth" - Sherlock Holmes

"God and developers are in a constant battle. Developments to make their applications more idiot-proof, and God to produce bigger idiots!"

Answers

  • Cyberghost
    Cyberghost Member Posts: 46
    Sorry, to update it is the Item No. field on the Sales Line which is slow.
    "When you eliminate the impossible, whatever remains, however improbable, must be the truth" - Sherlock Holmes

    "God and developers are in a constant battle. Developments to make their applications more idiot-proof, and God to produce bigger idiots!"

Categories