How to Optimize automatically in Navision???

kishi_g

Hi,
I saw Optimize in File -> Database -> Information-> Tables -> Optimize.


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




Thanks & Regards,
kishore....

Marije_Brummel

I think expandit does exactly that.

http://www.expandit.com/

Waldo

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), ...

ara3n

Here is how-to.

http://www.mibuso.com/forum/viewtopic.p ... tion+timer

Waldo

That's also how ExpandIT does it, isn't it. Using the "sendkeys"?

David_Singleton

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.

kishi_g

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

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.

hawwa

very sure will reduce size and improve performance on SQL Option.