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
HKAMEL
0
Comments
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.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!