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?
Size of the Base-file
Size of the Base-file
OpenOffice 4.5.1. on Windows 10
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Size of the Base-file
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.
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
From the database menu select Tools>SQL and execute the following two commands.
Code: Select all
CHECKPOINT DEFRAG;
SHUTDOWN COMPACT;
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11