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?
"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!"