Bad perfomance when posting journals

maris2000

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?

DaveT

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.

maris2000

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

Did you analyze this by using the client monitor?

maris2000

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

I am just doing that.
What sholuld I be awere of when analyzing the results of the client monitor.

Waldo

With "nothing happened", you mean "same performance" or "just the same issue then before"?

ta5

I guess you are using native server. Did you set commitcache=yes on the server?

maris2000

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

I have commit-cache on the server, and the server is native.

Waldo

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 ).

maris2000

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

Waldo

Hm, too bad we won't see what caused this ... but glad you "solved" it..

maris2000

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)