Subject RE: [firebird-support] why does restore last so long??
Author Leyne, Sean
Mat,

> My database has about 1.2 GB and I made a backup with firebird 1.0 and
I
> was trying to restore it with firebird 1.5
> Is it normal that restore can last more than 2 hours?? Usage of
> processor during that process is between 10-20 % - so what does engine
> do during that time?

I strongly suspect that you have indexes with a large number of
duplicate values. We saw this exact same effect on our databases.

Fortunately, v2.0 has a completely new disk structure for indexes which
is designed to handle duplicate index values much much more efficiently.
The net result is that restores FLY!


Sean