Bad perfomance when posting journals

maris2000
maris2000 Member Posts: 71
edited 2009-01-13 in NAV/Navision Classic Client
I have two forms: Wage General Journals1(form1) and Wage General Journals2(form2).
Posting goes fine on the form2, but it take some time to post on the form1.
The both forms are almost identical, they have same source table and use the same codeunits.
I was trying to find out why the posting is so slow on form1, but still have no clue. ](*,)
Can anybody please help with this perfomance issue?

Comments

  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    Check you filters - you might be filtering on a field that is not part on the primary key or any key. To resolve change/create the key.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • maris2000
    maris2000 Member Posts: 71
    I'm back agin with my perf. problem.
    Sorry, but I do not undestand how the keys could be a problem, when the both forms use
    the same tables and the code units.
    Maybe I sholud just make a new form and delete the old one.
  • Waldo
    Waldo Member Posts: 3,412
    Did you analyze this by using the client monitor?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • maris2000
    maris2000 Member Posts: 71
    UPS #-o
    I forgot to mention the difference between the tow forms.
    On the form2 the properties InsertAllowd and Delete are both set to "No" ;
    while the same properties on the form1 are set to "Yes".
    I've tried to change the properties, and nothing happend.
  • maris2000
    maris2000 Member Posts: 71
    I am just doing that.
    What sholuld I be awere of when analyzing the results of the client monitor.
  • Waldo
    Waldo Member Posts: 3,412
    With "nothing happened", you mean "same performance" or "just the same issue then before"?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ta5
    ta5 Member Posts: 1,164
    I guess you are using native server. Did you set commitcache=yes on the server?
  • maris2000
    maris2000 Member Posts: 71
    nothing happened = the same bad perf.
    This :bug: really sucks.
    I'm still not donne with Cliant monitor. It takes some time to post.
    I'll be back with the results
  • maris2000
    maris2000 Member Posts: 71
    I have commit-cache on the server, and the server is native.
  • Waldo
    Waldo Member Posts: 3,412
    The client monitor shows you which statement(s) in your C/AL are slow (elapsed time).

    A long shot:
    Have you set up the Object Cache = 0? This can cause some performance issues as well (allthough it should be the same problem at both forms :|).

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • maris2000
    maris2000 Member Posts: 71
    Hi again
    I had checked all the slow statements, wasted some time on that and still have no clue why the posting takes ages.
    That's why I have decided to make a new form, and now posting works fine.
    Tahnk you all for your help. I appreciate it.
    Thanx :D
  • Waldo
    Waldo Member Posts: 3,412
    Hm, too bad we won't see what caused this ... but glad you "solved" it..

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • maris2000
    maris2000 Member Posts: 71
    Yep, I think so too.
    I had to do ti this way because of time pressure.
    I'll get back on it as soon as I can, because I would like to see what caused the problem.
    Greetz 8)

Categories