Hi,

We use Firebird on 100's of sites and we have recurring issues where
after a while the databases will get progressively slower to the point
where they eventually become unusable.

We think these issues come about from where our systems were initially
on Firebird 1.5 and have been progressively upgraded to 2.5 (although
still running on the same initial database) I have been looking into
the ODS versions of the databases as I assume this could be caused by
the databases being in older ODS formats whilst running on a newer
version of firebird.

Databases vary in size from 500mb to up to about 9gb. The tables in
question that get very slow can have millions of rows in them.

This can pretty much always be resolved by performing a backup/restore
into a NEW database (doing the same backup/restore into the existing
database will not resolve it)

A few questions :

1. When doing a backup/restore I assume it always converts it into the
ODS of the firebird server being used? What differences are there
between restoring into the existing database or into a new one (I ask
this because we seem to only be able to resolve our issues by restoring
into a new database)

2. Is there any way to stop us having to do this, it seems very
unnecessary to have to do this - surely firebird should handle working
with old ODS formats? - I have been investigating gfix -sweep but its
not very successful.

NB - this has only become an issue since upgrading all our sites to
Firebird 2.5, before then we had not really had problems like this.

thanks for your help.

Toby


[Non-text portions of this message have been removed]