Size of the Base-file

Creating and using forms
Post Reply
vj88
Posts: 1
Joined: Wed Aug 08, 2018 3:03 pm

Size of the Base-file

Post by vj88 »

Hello,

I'm new here, so I don't really know if this is the right place to post this question.

I wanted to make a library sytem with Base for a nonprofitorganisation. Because I was not very familiar with it, I've first made a fictional library of around 50 books to try it out. Now I want to use the same file to start the actual library. Although I've deleted the initial forms from the database, the filesize doesn't get smaller. I don't get it.

Can someone help me with this problem, or is it advisable to start a new database with my new knowledge?
OpenOffice 4.5.1. on Windows 10
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Size of the Base-file

Post by UnklDonald418 »

In general database engines don't automatically do any housekeeping because as databases grow larger it can become a serious performance issue.
From the database menu select Tools>SQL and execute the following two commands.

Code: Select all

CHECKPOINT DEFRAG;
SHUTDOWN COMPACT;
Exit the database and check if the .obd file got smaller.

When using the standard issue Embedded database (look in the lower left corner of the main window) be sure to make frequent backups. An .obd file is actually a zip archive containing all the tables, queries, forms and reports. If anything goes wrong with the zip process (at some inopportune moment it probably will) the file will be corrupted and the data lost.
Using a Split database model where the data is stored outside the zip archive reduces the chance of that happening. Regular backups are still necessary.
[Wizard] Create a new 'split' HSQL 2.x database
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply