Increase in file size *.mdb



  • Implemented by:

    1. I'm building an OBD.
    2. In Delphi, I clean up her request for DELETE from MyTable;
    3. In Delphi, I'm adding N records INSERT.

    Subsequent to this, the size of BDE ~400 CB. Repeat steps 2.3.the same number- 700 Cb. After a fifth-sixth terrain, the size reaches 4.5 mb (!) and doesn't grow much further. It seems that the second step records are not removed, but no, watched the OBD in Access, after step (2), the base is empty.

    Question two:

    1. Why is this happening?
    2. How do you fight it?

    P.S. Working through ADOCommand


  • QA Engineer

    When the record is removed, it is not physically removed from the disk but is marked as remote. In postgresql and sqlite, there's a SQL VACUUM team.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2