Entry-View from navigate-window

Rene70Rene70 Member Posts: 25
Hi there,

when searching for a document no. using the navigate-window, everything works fine. When I open a specific table, watching the ledger entries, Navision sometimes loops through all entries. After looping through Navision shows what it has to show. This looping then lasts up to 3 minutes. It happend not very often, only sometimes.
Has someone any idea why this happens?

We are using SQL2005, Nav4.0SP2 engine, Nav3.7Code.

Thanks for your help.

Comments

  • kinekine Member Posts: 12,562
    It seems like wrong use of keys. Try to define good SQL index (through Navision Keys) starting with best-selectivity field used in the filter for that form.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.