How to Optimize automatically in Navision???

kishi_g
kishi_g Member Posts: 162
edited 2008-05-14 in NAV/Navision Classic Client
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_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I think expandit does exactly that.

    http://www.expandit.com/
    Marije Brummel | Freelance Business Central Specialist
  • Waldo
    Waldo 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
  • ara3n
    ara3n Member Posts: 9,258
    Here is how-to.

    http://www.mibuso.com/forum/viewtopic.p ... tion+timer
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Waldo
    Waldo 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_Singleton
    David_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_g
    kishi_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.
  • Waldo
    Waldo 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
  • hawwa
    hawwa Member Posts: 106
    very sure will reduce size and improve performance on SQL Option.
    www.navision-girl.com

Categories