mibuso.com

Microsoft Business Solutions online community
It is currently Sat Jul 26, 2014 7:13 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Strange Navision reactions on SQL2000
PostPosted: Tue Dec 22, 2009 10:54 am 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Hello,

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 ?


Top
 Profile  
 
 Post subject: Re: Strange Navision reactions on SQL2000
PostPosted: Tue Dec 22, 2009 11:21 am 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7683
Location: Milan
Country: Italy (it)
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 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: Strange Navision reactions on SQL2000
PostPosted: Tue Dec 22, 2009 1:22 pm 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Thanks for that reply, :D

Without currency filter it works well.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: