Size of the Base-file

Creating and using forms

Size of the Base-file

Postby vj88 » Wed Aug 08, 2018 8:09 pm

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
vj88
 
Posts: 1
Joined: Wed Aug 08, 2018 3:03 pm

Re: Size of the Base-file

Postby UnklDonald418 » Wed Aug 08, 2018 10:40 pm

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   Expand viewCollapse view
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.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1225
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Forms

Who is online

Users browsing this forum: MSN [Bot] and 3 guests