Which tables should be optimized?

quillo

By buil int "table optimizer". I read, log time a go about it, but I don´t remeber. It said something like, ledger entry tables should be optimized, but tables like item o vendor shouldn't.

Does anybody knows any rule about it?

Thank you.

David_Singleton

There is no rule. You need to optimize the tables that need optimizing.

The optimization bit is the easy part. The work is determining what to tune, and that is specific and different for every database.

kapamarou

I usually optimize all the tables.

I remember a white paper from microsoft though, that mentioned that tables like Ledger tables should be optimized daily.

I don't see any reason why you shouldn't optimize the rest.

kapamarou

OK. My memory fooled me... :oops:


It's not from MS...

It's here..

http://www.mibuso.com/dlinfo.asp?FileID=356

matttrax

The tables that get hit the most should be optimized. These generally include the ledger tables, posted documents, etc.

David_Singleton

kapamarou wrote:

OK. My memory fooled me... :oops:


It's not from MS...

It's here..

http://www.mibuso.com/dlinfo.asp?FileID=356

That paper is very outdated and should not be relied upon for current systems.

kapamarou

David Singleton wrote:

That paper is very outdated and should not be relied upon for current systems.

Yes it is very old.

And this Must be taken into consideration from anyone reading it.

quillo

I know It sounds strange, but I read (I think it was a 2.60 guide) that in some kind of tables (maybe masters), performance could be even worst after optimization.