db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Pearson <j...@emnico.com>
Subject Re: Derby Maintenance Activities
Date Mon, 01 Mar 2010 10:39:52 GMT

Does anybody have any experience of using these calls in anger on a live 
system or some recommendations on best practise.


On 25/02/2010 13:19, Jon Pearson wrote:
> Hi,
>     we are currently using Derby  to store device inventory 
> data for a Network Management application where the data is collected 
> and uploaded regularly during the day so there are a significant 
> number of inserts/updates/deletes, depending on the number of devices 
> being managed, happening throughout the day.
> Are there any guidelines or recommendations from user experience 
> relating to the optimum frequency of the following activities?
> Note: We are currently updating statistics daily while the system is 
> up and we are compressing the DB monthly using offline scripts
> Thanks
> Jon

Emnico Services Limited, Dauntsey House, Stonehill Green, Westlea, Swindon SN5 7HB
Company No. 06390113

This message is confidential and may contain privileged information.  If you are not the addressee
indicated in this message (or responsible for delivery of the message to them), you may not
copy or deliver this message to anyone or take any action in reliance on it.  If you have
received this e-mail in error, please delete it and notify the sender as soon as possible.
 The Emnico group of companies do not accept any liability for any harm that may be caused
to the recipient's system or data by this message.  Please carry out virus and other such
checks as you consider appropriate.

View raw message