Systems gets slow when User tries to get receipt lines

jaypee10

Hi everybody

we have a real problem when we try get receipt lines into invoices.
Navision hangs up or lasts very long to show the Purch. receipt lines.
This happens not always but often.

We have Nav3.7B on a Sql 2000.
The Table Purch Receipt lines has about 2GB.

Things we already tried (without success):
- view deadlocks with other users,
- Run Client monitor; but the key is 'optimal'.

other things we mentioned:
Physical I/o gets higher and higher
User blocks himself when getting Purch. receipt lines
no network traffic during hangs


Can anyone give some hints?

SLF25

Our client had this problem.

The problem was in Purch.-Get Receipt Codeunit, the SETCURRENTKEY on Run trigger wasn't optimal. i added a new better key and now it is ok, but you have to be careful that the key doesn't change the order of lines outside Pay to Vendor No.

jaypee10

Thanks for your answer.

We already tried this but how you said, the order changed.
so we deleted this change again

can you post the code and key?
this would be great.
thanks.

SLF25

PurchRcptLine.SETCURRENTKEY("Document No.","Pay-to Vendor No.","Line No.","Qty. Rcd. Not Invoiced");