Compact Database

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Compact Database

Viewing 3 reply threads
  • Author
    Posts
  • October 30, 2023 at 2:39 PM #50061

    Mike Guilbault
    Participant

    Under Maintenance, after pressing Compact Database, my db went from 48MB to 60MB. Is this normal? I would’ve expected it to go down, not up.

    Just curious.

    October 30, 2023 at 2:51 PM #50062

    Daniel Leu
    Participant

    Close the database and then reopening it again will bring the size down, as expected!

    October 30, 2023 at 11:14 PM #50064

    Brendan
    Keymaster

    The Compact Database operation performs an SQLite vacuum command, which writes to a WAL (Write Ahead Log) file. That’s what makes the file size grow. Closing and re-opening the document will delete that WAL file, then you’ll see the correct size after.

    October 31, 2023 at 2:39 PM #50068

    Mike Guilbault
    Participant

    Thanks… makes sense now.

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.