Author Topic: Local database size doesn't decrease after deleting diagrams and elements  (Read 2932 times)

MatthiasVDE

  • EA User
  • **
  • Posts: 196
  • Karma: +1/-0
    • View Profile
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

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #1 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

MatthiasVDE

  • EA User
  • **
  • Posts: 196
  • Karma: +1/-0
    • View Profile
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #2 on: September 09, 2020, 08:38:35 pm »
Thanks Geert, I suppose that I need to to this in MS Access?

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #3 on: September 09, 2020, 08:45:25 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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #4 on: September 09, 2020, 09:05:41 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.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #5 on: September 09, 2020, 09:55:34 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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Local database size doesn't decrease after deleting diagrams and elements
« Reply #6 on: September 09, 2020, 11:05:33 pm »
I meant a different "under" ;-) So in previous versions the menu path is different.

q.