Slow DATABASE after technical upgrade

just_user

Hello,

We have technical upgraded our native Navision Financials database 2.6 to NF ATTAIN ver. 3.7.
Just connect to database with 3.7 Clients.
After that run the server (3.7) and compile all objects.
Nothing is changed in code.

In result all time there is a problem with speed of posting sales order.

What can I do?
I read the forum and many people suggest to look for a right key, but if there wasn't problem in previous version, why there is a problem in 3.7 with the same key??

please, help ..
](*,)

W_Kattenbusch

Hi,
are you using a native or a sql database?

Iirc the sql database needs some time and transactions to come up to speed, since it does some kind of "learning".

Walter

kine

In case of MS SQL Server>

"Learning" is not problem of Navision because Navision is using hinting and do not let SQL to do the things in his way... (SQL can select only which index will use). Problem can be only cache.

But, there is another problem - I am not sure, but I think that in NF there are not SQL triggers on the tables with FlowFields. Navision 3.70 is using SQL triggers to update the SIFT tables and this can be the problem. Because this process need memory and if you do not have enough RAM, the triggers are recompiling each time you use some table... (they do not stay in cache for long time)...

Fermi

Hello!

I'm suffering similar things in another upgrade.

You've told all that you have done after upgrading, but I miss something. I think you should optimize all the tables before continue. When I did that, the speed came up.

Besides, if in the upgrade you've used 3.70A, you should revise codeunit 80. The last function looks in the table 21 without define an appropriate key. That was a difficult issue for me to find it.

I'm still treating to improve the speed of this database. If I get something, I'll post it. It keeps working slowly when clientes make applications, and it's slower in the first one of the day. It's quite funny.

Best regards

Manuel Barral Paul

kine

Still, I do not know, if you want optimalize the Native DB or MS SQL DB. It is big difference....