Ticket #1629 (closed assessed: fixed)

Opened 7 months ago

Last modified 7 months ago

Access database size becoming a problem

Reported by: jeroens Owned by: jeroens
Priority: urgent Milestone: 6.7 release
Component: Overall Logistics Version: 6.7 beta
Severity: major Keywords:


Deleted records keep occupying space in an Access database until explicitly deleted. This deletion happens though a "Compact" command, which has been available in EwE for quite a few years but which is rarely used.

The large database can prevent EwE from saving at some point, and can also occupy so much memory that the EwE execution is affected with unpredictable results.

We need an auto-compact functionality

Change History

comment:1 Changed 7 months ago by jeroens

  • Status changed from new to closed
  • Version changed from 6.0.7 to 6.7 beta
  • Resolution set to fixed

I added an option to auto-compact on model exit, which can be controlled from the basic EwE options form.
If set, any Access database is compacted when the model is closed. If this somehow fails, the original database is not affected.


Note: See TracTickets for help on using tickets.