On 07/02/2012 20:08, drew wrote:
Periodically you should perform the following. When finished using the database, open the SQL window. Menu [File>SQL] In the command window enter: SHUTDOWN COMPACT You should, after a short while receive in the status field the message: "1: Command successfully executed." At that point close the file. [you must do so as the database engine is indeed shutdown at this point] This will reduce the size of the file on disk and the memory used at run-time, and will increase performance on startup and shutdown. Depending on how actively you edit that table this period can be once a week or once every two weeks..can't say what is right for your specific usage.
Thanks Drew!!This worked a treat for me and I can see a marked improvement in my close-down times of the main DB and also closing Queries,
A real Gem!! (Is there any way of automating this do you know??) Ian Whitfield Pretoria -- 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