I'm surprised that there has been no response to this question :-(
Does anybody have experience of running statistics or compression which
they can share?
Jon
On 01/03/2010 10:39, Jon Pearson wrote:
Does anybody have any experience of using these calls in anger on a
live system or some recommendations on best practise.
Thanks
Jon
On 25/02/2010 13:19, Jon Pearson wrote:
Hi,
we are currently using Derby 10.5.3.0 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?
Statistics Update using SYSCS_UTIL.SYSCS_UPDATE_STATISTICS()
Db Compression using SYSCS_UTIL.SYSCS_COMPRESS_TABLE()
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.
