AnsweredAssumed Answered

Removing logs

Question asked by zladuric on Oct 28, 2010
Latest reply on Oct 29, 2010 by zladuric

We have an installation of alfresco with ~200,000 documents in it. Now, over the time, our database has grown, so now it's really huge - the ibdata file is 11GB big! We had to do an upgrade recently, but all the data came along - the database is still that big.
I've been told that this may because we didn't "truncate the logs" or something like that. And I've been suggested that I create a "blank" database and data, and do an export-import procedure about the documents.
While this is acceptable, I'm not sure if this is a long term solution. Will I have to do that every year? What if our needs scale up, we'll have to copy over the data every month or what?

So my actual questions:
Why is the database so big for only 200,000 documents?
Is there a way to remove the unnecessary data from the database other than doing this?