Very Slow after Upgrading to 3.70

Fermi

Hello, friends.

I've just upgraded a database from Financials 2.60 to MBS 3.70, and even after optimize the database, the system takes too much time to post a document, i. e. a sales invoice. During the posting process appears on the screen a form with the message "Searching in Value Entry".

The user is getting impatient with this, and I don't know what else can I do.

If anyone can help me, I would be very grateful.

Thanks in advance and best regards.

Marije_Brummel

Looks like a missing key or something.

Try using the Client Monitor during the transaction and look for Records Read more than 10.

DenSter

That is definately a key issue. You need to find each SETCURRENTKEY on any Value Entry variable, and determine if the key set in those commands actually exist. If they don't you may want to consider adding those keys.

Fermi

Both of you were right. The problem was created by the last function present in the codeunit 90. There, you can see this:

(...)
IF ValueEntry.FIND('-') THEN BEGIN
ValueEntry.SETRANGE(ValueEntry."Document No.", PurchInvLine."Document No.");
IF ValueEntry.FIND('-') THEN BEGIN
(...)

I've just inserted a SETCURRENTKEY, so the final result is:

IF ValueEntry.FIND('-') THEN BEGIN
ValueEntry.SETCURRENTKEY(ValueEntry."Document No.");
ValueEntry.SETRANGE(ValueEntry."Document No.", PurchInvLine."Document No.");
IF ValueEntry.FIND('-') THEN BEGIN

You must create the key in the table Value Entry.

Thanks a lot, friends.