Subject | Re: [firebird-support] Database restore speed with IBExpert and Gbak |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-05-26T16:25:57Z |
Halim,
Restore is basically limited by single core throughput and I've hardly
seen restore being IO bound.
What you could try is to provide a much larger (temporary) page buffers
value (which you have to reduce before the restored database is going to
be used in production!) during the restore, which might help during
index re-creation.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> Thank you for your reply.What is the size of table vs. index data?
> I just tested a GBAK restore using -se(rvice) switch on a 1 GB DB. It
> took about 8 minutes. Restoring the same database using IBExpert took
> about 3 minutes.
> I'm looking for a faster restore time because I want to automate the
> process using a batch file. Our DB is over 50 GB.
Restore is basically limited by single core throughput and I've hardly
seen restore being IO bound.
What you could try is to provide a much larger (temporary) page buffers
value (which you have to reduce before the restored database is going to
be used in production!) during the restore, which might help during
index re-creation.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.