From The Document Foundation Wiki
How do I reduce the size of a .odb?
Since version 3.6 the software automatically compact bases. For older versions, you will find below explanations and steps to use :
- The development of a database (creation of tables, formulae, queries, reports...) usually proceeds by successive modification of its objects.