Sean wrote:

> Hi,
>
> My service uses embedded database 1.5 without SS installed. After
> deployment the service will run for long time with potential huge data
> (say, 50GB). Do I need to schedule some maintenance tasks to keep the
> database working smoothly?
>
> The database will be scheduled to backup once per week. Besides that,
> what else can I do?
>
> Your suggestions are highly appreciated!
>
> Best,
> Sean
>
>

Hard to say without more info from your side.

FB tend to be low maintanance, but the main thing you could do to keep
it screaming is to ensure your transactions are short, long transactions
make the volume of garbage (unnecessary record versions) high. This
could lead to performance problems.

If your data demographics changes a lot updating the statistics once in
a while will be a good thing to do.

Run gfix to sweep the database on off-peak time could be a good thing to.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br