How to Optimize automatically in Navision???

kishi_gkishi_g Member Posts: 162
Hi,
I saw Optimize in File -> Database -> Information-> Tables -> Optimize.


How can i run automatically this Optimize button with Batch Jobs????




Thanks & Regards,
kishore....

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
  • WaldoWaldo Member Posts: 3,412
    On SQL or Native?

    Native: Follow Mark's link
    SQL: there are other options: Maintenance Plan, delete zero sift records (Using SQLPerform or Stryk's tools), ...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ara3nara3n Member Posts: 9,256
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • WaldoWaldo Member Posts: 3,412
    That's also how ExpandIT does it, isn't it. Using the "sendkeys"?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • David_SingletonDavid_Singleton Member Posts: 5,479
    kishi_g wrote:
    Hi,
    I saw Optimize in File -> Database -> Information-> Tables -> Optimize.


    How can i run automatically this Optimize button with Batch Jobs????




    Thanks & Regards,
    kishore....

    Assuming Native, I think the question is WHY do you want to optimize? It may save you a little bit of disk space, but disks are cheap, and the performance overhead is probably not worth it.

    This is more a left over of the days when you had to pay for database space.
    David Singleton
  • kishi_gkishi_g Member Posts: 162
    Is Optimize only for decrease the disk space? Is it increase the DB Performance? Iam asking for both native and SQL DB's.



    Thanks & regards,
    kishore.
  • WaldoWaldo Member Posts: 3,412
    In SQL it's going to reindex and delete de zero records in the sift tables. This definitely helps performance.

    On Native, I'm not sure what it does (you can't monitor it). I gues it's going to defragment (indexes?), which helps DB space ... which helps performance ... but don't expect too much of it.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • hawwahawwa Member Posts: 106
    very sure will reduce size and improve performance on SQL Option.
Sign In or Register to comment.