Subject Re: [firebird-support] Refactoring database
Author Ann W. Harrison
Steve Boyd wrote:
> Are there things that I can do, in terms of the way the data is
> structured, to reduce the fragmentation and / or back versions? There
> are are a handful of columns, having to do with status and status dates,
> that are the cause of most of the updates to the table. Would moving
> these volatile columns to their own table make any difference?

The first thing I'd do is to use gstat to verify that fragments or
back versions are the source of the problem. If they are, and you're
not using 16K pages, I'd try that first.

Best regards,