On Thu, 2012-02-09 at 17:12 +0200, Ian Whitfield wrote: > 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??)
Howdy Ian Glad it helped. Automating? As in a custom menu item for 'Close after Compact' _or_ Every Friday compact the database? Thanks //drew -- For unsubscribe instructions e-mail to: users+h...@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
