You are viewing limited content. For full access, please sign in.

Question

Question

Reducing the size of the Workflow .MDF Database file

asked on May 2, 2016 Show version history

Hi Laserfiche Support, 

Do you have any suggestions for reducing the size of the Workflow database (.MDF file) size? 

Right now, we have a client that has a .MDF file that is 32 GB.

0 0

Answer

SELECTED ANSWER
replied on May 2, 2016

Run the statistics report to see what you have in there: from the Workflow Designer, open the Workflow menu and choose Create Workflow Statistics Report. You don't have to select any filters. This should give you an idea of the numbers of instances running for each workflow definition.

If any of the numbers looks higher than expected for any of them, then you might have a faulty starting rule.

If the numbers look as expected, you may want to tweak the number of days completed workflow history is kept in the database. By default, that's 30 days. The value can be updated from the Workflow administration console, under Advance Server Options.

Other possible causes for the size of the database can be excessive use of Track Tokens or inefficient starting rules.

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.