compacting a 500 mb goes to 1 gb?

[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

Thanks

[Brendan]

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.

[john cesta]

Yea, you’re right. Thanks

[Author]

Posts