Performance improvement from 3.7 to 4

suvidhasuvidha 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

  • kinekine 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.
  • suvidhasuvidha 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!
  • garakgarak 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!
  • kinekine 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_ChowAlex_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.
Sign In or Register to comment.