--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

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

Thanks a lot!

Is SS required for gfix to work? I am using embedded mode w/o SS
installed.

Best,
Sean