Community

ABBYY Database size is increasing day by day

Avatar
Written by Permanently deleted user
  • 2
Hi,
I am using ABBYY Flexicapture 10 Distributed. I have set an autocleanup of batches and autocleanup of eventlog and report data in Administration and Monitoring Console. As well as I am doing Database cleanup operation weekly. But still Database is getting increased day by day. As SQL Server 2005 express has only 4GB DB limit and my DB is soon going to cross 3.5GB. So if anyone have some tricks for keeping the DB steady in size then please let me know.
After observing table's size in database I found that "EventLog" table is taking 1.5 GB space. Deleting the records from this table would create problem in functioning of the project?
What is the option to delete Error logs and warning logs? as those logs are not getting cleared by autocleanup of event logs.




Thanks.

Was this article helpful?

0 out of 0 found this helpful

Comments

2 comments

Sort by Date Votes
  • Avatar
    Permanently deleted user
    Rahul,

    As you can tell, the DB stores a lot of information. The clean up basic set a flag on the record for deletion but doesn't delete until there is some down time. Are you constantly processing? If so, you might want to stop the processing server for about an hour just so that it can preform the actual deletion in the DB. Also if possible, go ahead and delete the event log record if you want. Check the Admin and Monitoring console and reducing logging if you can. Other than that, make sure you're on the latest release of FC10. If the DB gets too large, you will get performance issue.
    0
  • Avatar
    Permanently deleted user
    EventLog table has some indexes defined. Two of them use a lot of space e.g. when our db became of 4GB in size then about 1.4GB were used by these two invoices. We just dropped these invoices and shrunk the db.. Indexes at most will make the report generation slow (but at same time it will reduce time taken in inserting rows to EventLog table and so will reduce load on Abbyy db). I feel Abbyy should review whether it wants to keep these invoices at all. The indexes are-
    IX_EventLog_BatchIdDate
    IX_EventLog_TypeUserTask
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post