topic Re: Clean history periodically in Alfresco Archive

Clean history periodically

pred05 — Wed, 01 Jul 2015 09:45:59 GMT

Hi, i am sure to have seen somewhere in the userguide that we can configure a periodical clean of the historic. Or a time to keep the history's data before clean.I have found some topic about the query for clean the history. If it isn't possible to configure it, i think i'm going to make a job which

Re: Clean history periodically

martin_grofcik — Wed, 01 Jul 2015 10:26:30 GMT

Hi,

i am sure to have seen somewhere in the userguide that we can configure a periodical clean of the historic. Or a time to keep the history's data before clean.

I am not aware of it.

I have found some topic about the query for clean the history. If it isn't possible to configure it, i think i'm going to make a job which execute these query.
I would prefer archive. Why do you want to clean up history - If you do not need history why do you collect history data?

Regards
Martin

Re: Clean history periodically

pred05 — Wed, 01 Jul 2015 11:15:32 GMT

Ok thanks you. So i'm mistaken, i think i confuse with an other thing.
I have to use multiple database for handle several workflow. In each database i want to enable history. But i will have a lot of instance so i fear about the database performance. Also, i want to have a unique database which contain all history of each workflow to ease the post processing on this data (to visualize with several chart some data like the time's average to complete a process for example).

Re: Clean history periodically

trademak — Wed, 01 Jul 2015 13:51:13 GMT

Right, we have defined all historic tables without foreign keys, to make it easy to move or copy any data.
But there's not specific logic doing that, it has to be created per use case.

Best regards,