Subject Re: [firebird-support] GBAK and the -i flag
Author Alexandre Benson Smith
Tom Miller wrote:
> On a large table (lots of records / rows) the DB has to recalculate the
> index on every record.
> I did a test on a 3.7 GB database
> No -i Flag: 35 minutes
> with -i Flag: 24 minutes
> Activating the indexes through DB Workbench took about a minute, so that
> was 10 minutes faster.
> Tom Miller
Hi !

AFAIK gbak activates the indices after the data load. This is why I
think your approach should not give any benefit (unless you don't
activate all indices)

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil