My database is getting too slow, and i want to optimize it using SHIFT Optimization. Please someone post how to perform SHIFT Optimization.
Hi Jagesh
Not sure what you mean by SHIFT optimization, could you perhaps mean SIFT optimization?
SIFT optimization was a lot more relevant with the non SQL version of the database, you will get a lot more performance from other areas such as SQL optimizations and looking at possibly more SQL memory, faster HDD's setups in the server
If you want to run the optimizations however it may slightly improve performance however i suspect this change may be so small as to be unnoticeable
Open the classic NAV client, with the database opened click on "File" -> "Database" -> "Information"
On the screen that opens click the tables button at the bottom
Select a range of tables and hit the optimize button,
Be aware that this may take a long time to run on big tables so you can do ranges of small tables but only a single table whee there are a lot of records
Hope this helps
Cheers
Nev
Neville FoynNAV Developer, Consultant & Trainer (Since 2001)MCTS NAV, CRM, Sharepoint, SQLMCITP NAVMCT