Does running ccmdb repair -repair_index in Synergy improve performance?

Glyn_Mo's picture
Glyn_Mo asked on May 4, 2011 - 11:33am | Replies (1).

Hello

I've been reading through the Synergy Admin guides we have and one of them recommends running this command weekly, after the ccmdb backup has run.

To the best of my knowledge, this is something we haven't been doing.

Before I run it though, I'm wondering if anybody knows (a) how long the command takes to run, and (b) is repairing the indices likely to increase Synergy performance at all?

The size of our databse is as follows:

[code]bash-3.00$ ccmdb info -k size <db_name>
2953216 KBYTES[/code]

Thanks
Glyn

1 Answer

baynes's picture
baynes replied on May 4, 2011 - 4:43pm.

It normally takes a few minutes. Depends on the amount of metadata in the database.

In extreeme cases - where very large amounts of data have been added to a database since it was last done (or the database unpacked) it can give a 2 to 3 times performance boost but in most cases it will be much smaller.

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.