Systems gets slow when User tries to get receipt lines

jaypee10
jaypee10 Member Posts: 13
edited 2007-10-30 in NAV/Navision Classic Client
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?

Comments

  • SLF25
    SLF25 Member Posts: 37
    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
    jaypee10 Member Posts: 13
    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
    SLF25 Member Posts: 37
    PurchRcptLine.SETCURRENTKEY("Document No.","Pay-to Vendor No.","Line No.","Qty. Rcd. Not Invoiced");

Categories