|Subject||Re: [firebird-support] Gbak utility|
> To summarize:You can use GBAK -i and all indexes will be restored as INACTIVE. So
> Fill database
> Set index (takes about 6 hours)
> Create backup (which removes index)
> Create database from backup (which adds the index, again 6 hours)
> So the index is created twice.
> Is there a way to improve this? F.e. by putting a inactive index in
> the database that gets activated at the create database from backup?
you can start to work with the application and activate the indexes in
You can also use the GFIX -mo[de] read_only switch to set an existing
database to read-only-mode.