Re: [libreoffice-users] Command to clean-up LO Base Database.

On 04/07/2013 07:11 AM, Ian Whitfield wrote:
> Hi All
>
> Last week I posted a question to the Forum ...
>
> /*Command to clean-up LO Base Database.*//
> //
> //I have been using OO/LO Base for some years but have now converted 
> to running MySQL with an LO Base Front End - Which is far superior and 
> to be recommended!! //
> ////
> //I do however keep an old copy of the embedded Base file going and I 
> notice it has become very slow. //
> //I know there is an SQL Command you can close it with to clean it up 
> for this and I used to use this. //
> //I thought I had made a note of this but can now not find it!! //
> ////
> //Can anyone give me that Command please?? /
>
> I never saw it come up on the Forum but I did get one reply directly 
> to my eMail from Reizinger Zoltan
> (Thanks for that!!).
>
> He suggested I use "SHUTDOWN SCRIP". This reminds me that the Command 
> I want DID start with "SHUTDOWN" but I'm sure the word/command after 
> it was different.
>
> I hope this posting gets through to the Forum and that somebody can 
> jog my memory for what I'm looking for!!
>
> Thanks a lot
>
> IanW
> Pretoria RSA
     Suggestion first; answer afterwards.

      Base uses HSQLDB as its database engine (version 1.8) There is a 
user guide for this version of HSQLDB. You should have a copy. If you do 
not, I can send you a copy off list. If you did have it, you could have 
searched for SHUTDOWN and found the paragraph that I quote below. Using 
the user guide as a reference will be much quicker than sending an email 
and then waiting for a reply.
      Additional comments:
1) When I searched my copy for SHUTDOWN, the first thing that appeared 
was in the table of contents. There is a complete section written on 
SHUTDOWN.
2) It is much better to have references you can consult for information 
than to rely upon your memory some time later. In such cases, you are 
likely to only remember part of what you need or not have the 
information correct.
3) If you know what you are doing, you can extract the database files 
from the Base database document file. Then you can connect to the 
database files using the HSQLDB database engine. This works as well as 
MySQL. You can even use the latest HSQLDB database engine (2.8, but 
possibly higher).

Answer in a paragraph:
     "When SHUTDOWN is issued, all active transactions are rolled back. 
A special form of closing the data-
base is via the SHUTDOWN COMPACT command. This command rewrites the 
.data file that con-
tains the information stored in CACHED tables and compacts it to size. 
This command should be issued
periodically, especially when lots of inserts, updates or deletes have 
been performed on the cached
tables. Changes to the structure of the database, such as dropping or 
modifying populated CACHED
tables or indexes also create large amounts of unused file space that 
can be reclaimed using this command."

--Dan


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted