Strange Navision reactions on SQL2000

ouredpouredp Posts: 56Member
edited 2009-12-22 in SQL Performance

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 ?


  • krikikriki Posts: 7,817Member, Moderator
    You should trace on SQL if the correct index is used all the time. When it is slow, it is possible that a wrong index is used.

    Another problem can also be that field 91:"Currency Code" in table 121:"Purch. Rcpt. Line" is a flowfield. This can create a lot of performance problems because there is a filter on that field.
    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

    »»» Mark your calendar: NAV TechDays 2015 - 19 & 20 November 2015 (!) ««« Visit the conference website:
  • ouredpouredp Posts: 56Member
    Thanks for that reply, :D

    Without currency filter it works well.
Sign In or Register to comment.