Subject | Re: Gbak utility |
---|---|
Author | paulfirebird@ymail.com |
Post date | 2010-08-16T07:08:46Z |
Does anyone have an idea/solution for this?
--- In firebird-support@yahoogroups.com, "paulfirebird@..." <paul.vanderlinden@...> wrote:
>
>
>
> --- In firebird-support@yahoogroups.com, Stefan Heymann <lists@> wrote:
> >
> > > To summarize:
> > > 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 use GBAK -i and all indexes will be restored as INACTIVE. So
> > 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
> >
>
> I want exactly the opposite, because I want to make ready-to-use databases. F.e. an option that activates inactive indexes
>
> Greetings,
> Paul
>