Posting Delay on Sales Invoice

RiyadBaker

Hi All.
I'm performance issue on Navision 5 ,this issue happend for some items when sales invoice posting !! i have tried to optimize the value entry table but still same .

Plz advise how we can go ahead with these kind of problems .

thanks in advance .


RS

matttrax

Run code coverage to see which objects it's getting slowed down in.
Run client monitor to see where in that object the slowness might be.

How large are the orders? How many lines, average quantity, etc? A serialized order with 10,000 pieces on it will take significantly longer than a non-serialized order, for example.

Belias

matttrax wrote:

Run code coverage to see which objects it's getting slowed down in.

hi matttrax, can you explain this please?I am more or less familiar with code coverage (i have used it sometimes), but i don't know any feature that shows which object is slow.
For performance issues, i only use client monitor!

matttrax

Must be having a bad day. You are correct, code coverage does not show you anything about performance. For some reason I was thinking the ratio field was a "time spent in that object" field...like I said, not thinking clearly today.

I should stop answering posts so early in the morning #-o

Belias

i think that nobody of us have used Code coverage a lot

RiyadBaker

](*,) .. even me i just open the code coverage but to be frank i don't have any idea whats going on ...
but the strange on this case its happen just for two or three item and as answer of your question (matttrax) the quantity is too small like bello 500 .

however ,from where i can find the client monitor as per my under standing it's object i have to import it . could you help me to find this one ..

thanks dude .

Belias

tools->client monitor
if it's greyed, you don't have developer license...
find some documentation about it, but basically you should do:
-star client monitor with the button
-do something you want to monitor
-stop client monitor
-filter for "parameter no." = 100
-filter for number >100 (or something else, this is the elapsed time in millisecs)
-remove all the filters in order to see what's the "bad" instruction

RiyadBaker

thanx Belias for your reply ..
I have tried that but i realized something .

-This issue coming for some item ..(Mention before )
-I create new DB and restore it on the same server same issue is replicated .
-I create same company on separate server .. this issue is not replecated ?

Now back to the assumption that DB base need to be optimized ? if so which the table i have to do and what's the common way to this optimization .

Thanks.

Belias

i think you're taking optimization too easy...it's not really a "one touch and go"...
and if you're on SQL...well...call an exepert. (are you on sql or nav?)
try to search "performance" or "SQL performance" in mibuso and you'll see how many topics there are about it.
as a first hint, try to use client monitor as i said in order to see what are slow instruction(queries, if you're sql), then check if there are bad index or there isn't a correct index for your set of filters.
you said "only some items": maybe these items have some particular values that get them into an "IF" statement which calls something slow...