Subject | Re: [firebird-support] Gbak utility |
---|---|
Author | Stefan Heymann |
Post date | 2010-01-29T12:46:37Z |
> 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
parallel.
You can also use the GFIX -mo[de] read_only switch to set an existing
database to read-only-mode.
Regards
Stefan