Trainz DB Rebuild or Not?

[sultan1966]

In my previous life I believed in database reindexing. Is the Trainz database rebuild the same thing as a reindex? Either way, Is rebuilding the db on a regular basis recommended or do we go on the "If its not broke..Leave it alone" principal?

 

[pdkoester]

I rebuild the database when it has a problem, or migration to a newer version.

 

[JohnnyC1]

I do a BBR after adding/modifying/removing multiple assets. Shut down and restart game.

John

 

[PortLineParker]

I only ever do a DBR if I have several corrupted assets for seemingly no reason whatsoever, but I can't remember the last time I ran one.

Cheers,

PLP

 

[JCitron]

The answer is... Do this only when there's a problem.

There are two kinds of DBRs:

A regular or quick rebuild which is basically a reindex. This is done if there's some odd thing or two occurring that can't seem to be resolved.

Then there's the Extended Database repair, aka the EDBR.

When you run an EDBR, it does the same as a DBR but then goes further by deleting the cached files and validates content. This process can take a long time and sometimes can lead to further problems.

After completing either kind of repair, it's recommended to view Faulty assets. During the repair process, more so with an EDBR, content will be falsely marked as faulty. To clear the error, select view errors and warnings from the context menu after selecting the faulty assets.

 

[sultan1966]

Thanks for all your input. Now I just have to keep my finger off that rebuild button unless I need it.