Performance improvement from 3.7 to 4

suvidha

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 :?

kine

There WAS improvements... you have possibility to define SQLIndex for each key, you have new commands like FINDFIRST, FINDLAST, FINDSET etc.

suvidha

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

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 ....

kine

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.

Alex_Chow

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.