Re: [libreoffice-users] LO Base questions

On 09/02/2012 18:53, drew wrote:
> 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

Good question Drew!!!!! (thinking.......???)

I guess either would work but I think the first option would be my first 
choice. But rather 'Compact and Close'.

On reflection - whichever is the easiest to implement.

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