Navision 4.0 very slow on SQL Server DB

kamel.hedi

We use an SQL Server Database, and operations on Navision 4.0 in the client computers are very slow (Filtering, posting, ....).
We have upgraded from Navision 2.60 to 4.0 and with the 2.60 version, the application wasn't slow like on the 4.0.

Does someone have solution, some parameters to adjust for making the DB more fast ?

Thanks

kriki

From 3.01, fore the customer-,vendor-,item ledger entries you have an extra table to fill up. This already slows a little.

But the biggest part comes from all the indexes in Navision.
Even if you put SETCURRENTKEY, SQL doesn't care about it and chooses the index he wants. For SQL the SETCURRENTKEY translates in an ORDER BY.

So a lot of keys, you have to keep enabled, but you can set it's properties "MaintainSQLIndex","MaintainSIFTIndex" to NO. In this way SQL has not to maintain them. For the SIFT-fields, a record is maintained for every field in the key (dates use 3 records!)

Search the forum on SQL for more info.