Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

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."


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.