compacting a 500 mb goes to 1 gb?

Viewing 2 reply threads
  • Author
  • January 19, 2023 at 5:35 PM #48731

    john cesta

    Why does compacting a 500 mb data base resolve to over 1 gb? Even if I delete records etc.

    Then when I go into compacting again it again shows 500 mb and resolves to the same 1 gb?

    On the disk it’s only 500 mb


    January 19, 2023 at 8:22 PM #48738


    Close and re-open the document. That’ll shrink it again.

    The reason is because when you compact the database, it’s also performing a vacuum database function and that writes to a WAL (write ahead log) file, which is within the document folder. When you close and re-open the document, that WAL file is deleted. So then the calculation will be accurate.

    January 21, 2023 at 10:04 AM #48770

    john cesta

    Yea, you’re right. Thanks

Viewing 2 reply threads

You must be logged in to reply to this topic.