Slow After Upgrade

teckpoh

Dear All,
I upgraded nav from v3 to v5. Now my nav db is in v5 and i noted for certain customized form that i created b4 is running slow after upgraded and this is not happen in older version.
As an example: i got Form A and when the time i click on menu button on the form itself to called another form(Form by apply some filtering it take very long time to prompt up the Form B.

Erm..i juz wonder that should i need to do some fine-tuning after upgraded to nav5 and how to make it? Any Idea?? 10s in advance~~



Cheer,
teckpoh

kine

Native DB Server or MS SQL Server?

garak

as kine ask: which kind of servertype. We think it's the sql. Then the other question, which version, build no, of SQL (if it is sql).

Regards

teckpoh

Thank's kine and garak for the replied..i use mssql 2005....

kine

1) Be sure, that IndexHinting is disabled (search for IndexHinting for more info)
2) Of course, there is big change in how the SIFTs are handled (or "how they were replaced"). It means in some cases optimalization is needed

garak

Take a look to the new SIFT Technologie. Since 5.01 there a index. views. Before it was tables.
Also check if indexhinting is activated or not.

for mor infos, check the post in subforum SQL Performance.

Regards

teckpoh

hi kine,
i disabled the indexhinting for the specific table already but the performance still the same...take long time to prompt up the form B... any idea? or i miss out something

kine

Best will be to use SQL Profiler to catch the problematic query, analyze it and make proper changes. Without more info it is not easy to give you some solution.

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL Performance' forum]