We are sometimes facing a problem with performance of retrieving open Purch.Rcp.Lines
in Form 51 Purchase Invoice.
The most of the time it works fine, performance is good, but in some cases (could not identify any logic) Navision begins to read thru all Receipt Lines witouth using the right key set in setcurrentkey.
-I/O in session monitor high for that login
- setcurrentkey is set properly to get shortly the records
- performance can be slow even for a vendor with less receipt lines
Navision 4.3 , SQL2000
Is there any explanation about this ?