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