--- In firebird-support@yahoogroups.com, PenWin <penwin@...> wrote:

>
> >> Is there a way to completely regenerate all indices in a database
> >> without running through the full backup/restore cycle? It's been my
> >> experience that over months or years, the database keeps getting slower
> >> and slower, but a backup and immediate restore fix it to run at
> >> full-speed again. I would like to achieve the same result without having
> >> to stop all other work. What I tried so far:
> >>
> > Are you sure that the index stuff is your problem and not transaction
> > related? What's the output of gstat -h at the time you think the
> > database is getting slow?
>
> No, I am not sure. I will try to get gstat -h for the slow database (I
> can't do it right away as I am only getting backups from my users, not
> the production databases themselves). What should I be looking for?
>
> Pepak
>

You should check
1. existence of long running transaction
this is simple in FB2 by selecting from MON$TRANSACTION
if you see there some very old transaction active then you find problem
2. what is your value of Sweep Interval - is it 0?
you can try run gfix -sweep and check if your problems are gone

Karol Bieniaszewski