Skip to Content
0
Former Member
May 07, 2010 at 07:41 PM

CMS Tables & Size Issue

66 Views

We have migrated from BO XIr2 to XIR3 and I am cleaning up the old CMS and Audit tables from my SQL Server 2005 database.

I noticed that the XIr3 tables are much larger than the XIr2 tables. 4 mb v 170 mb. I also have 2 sets of tables in the XIr3 schema. I have 2 Aliases, IdNumber, Infoobject and Relations. I only have one for Lock. For example I have cms_infoobject5 and a cms_infoobject6.

I do not believe I should have 2 sets of tables. Also is there a why to reclaim space?

Any thoughts on this?

Thanks

Pat