Very Slow Posting in NAV 2009

(0) Share

Report

Posted on by Dir All

Hi, I have a problem with the Journals, Output Journals, Item Journals, Item Reclass Journals, etc., this proves is very, very, very slow; it's take up 15 minutes!!

How I can correct the problem?

how I can improve performance?

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Very Slow Posting in NAV 2009

hi,

some standard checks

SIFT

Swith off SumIndexFields for large tables, will remove vsift views but can improve performances reducing locks on large tables

COSTS RECALCULATION

If are you using "Automatic Adjust Cost" > swith off function, make a scheduled job (on NAS) to recalculate costs

REBUILD INDEXES

Rebuld indexes on SQL Server or optimize tables on NAV

TRACING SLAW CALLS

run the process with SQL Profiler or the NAV Client Monitor

trace locks & deadlocks

check pending sessions on sql server > if you have, you need more memory
Francisco Bedolla 1,117 on at

Like (0)

Report

RE: Posting in NAV 2009

Well, we need more info in order to provide a solution.

Are you using native or SQL DB?

Which versión of nav client, RTC or classic?

Memory size of server and client?

In financial management, inventory, setup, inventory setup, the autom cost posting, expected cost post are selected? (I mean selected as TRUE).

in autom cost adjust which one is selected in the option field?
Dir All 89 on at

Like (0)

Report

Posting Very Slow

Hi, i have a problem with the Item Journals, Item Reclass Journals, Output Journals, etc. The posting is Very Very Slow. This proces takes up 15 minutes!!!

Do you know way?