Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: MatthiasVDE on September 09, 2020, 08:03:43 pm

Title: Local database size doesn't decrease after deleting diagrams and elements
Post by: MatthiasVDE on September 09, 2020, 08:03:43 pm

I'm testing with a script that create diagrams based on a CSV input. After each test I delete all the diagrams and elements that are created.
But when I look in the windows explorer to the size of my eapx file, it becomes bigger and bigger... I looks like the data is nog effectively removed after deleting all the diagrams and elements in my project browser.

I'm using EA 15

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: Geert Bellekens on September 09, 2020, 08:26:15 pm

Matthias,

.eapx is a (MS Access) database. If you delete stuff the allocated space is not released.

If you want to decrease the size of your .eapx you can do a compact. That will release the not used allocated space.

Geert

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: MatthiasVDE on September 09, 2020, 08:38:35 pm

Thanks Geert, I suppose that I need to to this in MS Access?

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: Paolo F Cantoni on September 09, 2020, 08:45:25 pm

Quote from: MatthiasVDE on September 09, 2020, 08:38:35 pm

Thanks, Geert, I suppose that I need to do this in MS Access?

You can, but you can also do it under Configure | Model | Integrity | Manage EAP/EAPX

Paolo

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: qwerty on September 09, 2020, 09:05:41 pm

Quote from: Paolo F Cantoni on September 09, 2020, 08:45:25 pm

Quote from: MatthiasVDE on September 09, 2020, 08:38:35 pm

Thanks, Geert, I suppose that I need to do this in MS Access?

You can, but you can also do it under Configure | Model | Integrity | Manage EAP/EAPX

Paolo

If you are under V15 or so.

q.

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: Paolo F Cantoni on September 09, 2020, 09:55:34 pm

Quote from: qwerty on September 09, 2020, 09:05:41 pm

If you are under V15 or so.

q.

This is valid up to the current version (v15.2 b1544).  I checked before I posted.

Paolo

Title: Re: Local database size doesn't decrease after deleting diagrams and elements
Post by: qwerty on September 09, 2020, 11:05:33 pm

I meant a different "under" ;-) So in previous versions the menu path is different.

q.