Re: [libreoffice-users] LO Base questions

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+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