Subject Re: why does restore last so long??
Author Ali Gökçen
--- In firebird-support@yahoogroups.com, mat <mpaczek@k...> wrote:
> Hi!
> 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?
> does any one know?
> mat

Hi,
what is your disk RPM?
what is the speed between south bridge and nort bridge of your
system?
what is your DDR type and frequence & latency time?
what is your primary and secondary cache RAM size and speed?
what is your disk access time speed?
what is your disk track to track access time speed?
what is your operating system and version?
is there any background or foreground task causing IO on bus?
how many indexes you have?
how is it take when you restore it with FB 1.0, is there any
difference?
did you noticed that i didnt asked even your CPU frequence? :)
back up and restore dont need to much CPU calculation,
they needs too much IO. as you guess IO speed of system is too less
than CPU2RAM speed.
feel you free to play digger when you restore your db..

Regards.

Ali