Inventory Handling

sabzamsabzam Member Posts: 1,149
edited 2014-12-01 in NAV Three Tier
Dear All,

What is the amount of items which is considered as decent for NAV to handle, as I had clients which would run into performance issues, after a couple of thousands.

Regards,

Steve

Comments

  • tinoruijstinoruijs Member Posts: 1,226
    The number of items present in a database is not important for performance.
    What can affect performance is the number of sales/purchase-orderlines there are on an order or invoice and the setup of the items.
    And how the inventory setup is (Automatic Cost Posting for example).
    I've seen bad performance in databases where orders were not deleted and kept in the database. Be sure to delete them.

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • sabzamsabzam Member Posts: 1,149
    Thanks
  • jubeljoyjubeljoy Member Posts: 154
    Also recommended you to delete un-necessary table records(Change Log with less than 1 Month records delete etc.) and optimise keys. After doing this you can able see huge impact on the system perfromance
  • sabzamsabzam Member Posts: 1,149
    Excellent thanks.
  • rico1931rico1931 Member Posts: 295
    jubeljoy wrote:
    Also recommended you to delete un-necessary table records(Change Log with less than 1 Month records delete etc.) and optimise keys. After doing this you can able see huge impact on the system perfromance

    Hi Jubeljoy,

    So I have this problem where the company wants to keep certain table records in the change log for forever ](*,) but I'm curious to what you are saying about optimizing keys.... can you explain this a bit more and where it needs to be done? Is this a Nav thing? or I'm going to guess it's a SQL thing.

    Thanks
    -rico1931
  • tinoruijstinoruijs Member Posts: 1,226
    rico1931 wrote:
    So I have this problem where the company wants to keep certain table records in the change log for forever ](*,)

    No problem for performance when change log keeps growing.

    Tino Ruijs
    Microsoft Dynamics NAV specialist
Sign In or Register to comment.