Performance improvement from 3.7 to 4

suvidha
suvidha Member Posts: 117
edited 2009-01-12 in SQL Performance
Hi,
It is said that there will be performance improvement in 4.0 compared to 3.7.
How can i prove this point??
please help :?

Comments

  • kine
    kine Member Posts: 12,562
    There WAS improvements... you have possibility to define SQLIndex for each key, you have new commands like FINDFIRST, FINDLAST, FINDSET etc.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • suvidha
    suvidha Member Posts: 117
    No,
    all this i know..
    mainly in 3.7 customer is facing locking problem
    so once they swich to 4.0 they want this problem to be reduced!
  • garak
    garak Member Posts: 3,263
    suvidha wrote:
    mainly in 3.7 customer is facing locking problem .... they want this problem to be reduced!

    Have you checked which tables are locked and during which process the tables are locked?
    Is this customized code or standard NAV code?

    And yes, with 4.0 (last ServicePacks) the Perfomance was improved. And with 5.01 it was also optimized ....
    Do you make it right, it works too!
  • kine
    kine Member Posts: 12,562
    suvidha wrote:
    No,
    all this i know..
    mainly in 3.7 customer is facing locking problem
    so once they swich to 4.0 they want this problem to be reduced!

    Changing to NAV 4.00SP3 or NAV 5.00SP1 (if they have SQL 2005/2008), will give mainly tools for better optimalization, it will not solve the problem automatically. It can give you better results, but in some cases you can have worse performance, but much more tools to solve it. :wink:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Note that you do not have to do a full upgrade to version 4+. You can just upgrade the executables.

    If you're using SQL, it may be wise to hire the folks at SQL perform to optimize it, then you take over the maintenence of it.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories