mibuso.com
Home› SQL Performance
Options

SQL Performance while Posting Item Tracking in Output Journa

HaraldAyasseHaraldAyasse Member Posts: 5
edited 2008-06-05 in SQL Performance
Hi,

when we are posting one Output Journal line with 5000 pieces and item tracking is active (means 5000 serial no. are linked to the Output Journal line) the system needs round about 2.5 hours time to do the posting.

We are using SQL 2000 and NAV 4.00 SP3.

Does anyone have any idea why NAV takes this huge amount of time and is there any solution to make it faster?

Thanks
Harald

Comments

  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    It is very difficult to give one single cause for that.

    Traditionaly NAV is overindexed and sometimes even wrongly indexed which causes especialy posting transactions to be slow.

    This could be the case in your installation.

    You can check this by running SQL Profiler and trace SP:StmtCompleted with a filter on 50 milliseconds.

    If inserts take longer than 50 milliseconds this is the case.

    There can also be other issues like SQL Cursors, memory/checkpoint, disk performance or network, but traditionaly the indexes are the cause.

    Good luck.
    Marije Brummel | Freelance Business Central Specialist
  • Options
    vikram7_dabasvikram7_dabas Member Posts: 611
    u have to check ur coding there will be some problem in coding if u r using setrange for filter than plz use get function it if u can apply in ur coding.ok
    Vikram Dabas
    Navision Technical Consultant
  • Options
    krikikriki Member, Moderator Posts: 9,089
    [Topic moved from Navision forum to SQL Performance forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.