Subject | RE: [firebird-support] Backup much faster than restore |
---|---|
Author | Maya Opperman |
Post date | 2013-05-08T06:37:32Z |
>> Got an interesting question from one of my customers:Thanks Peter
>> "The backup runs in 1 secs and 2 secs for zipping the file but the
> >restore takes 1min 32secs. Why is there such a difference in the time?"
> >Well, restoring obviously has to do a lot more work, as it has to
> >rebuild indices, and database structures, but it does seem like quite
> >a huge difference. Does that really explain the difference in speed?
> >(If need be, I can confirm the exact Firebird version, but I am
> >assuming it is Firebird 2.5, since they have just installed.) Thanks
>> Maya
>I believe that the integrity checks which are computationally more expensive are done on the restore rather than backup.
>This reduces the load on the server since backups are often done during operating activities and we don't want to impinge on operations.
> A restore would typically take the system offline unless it is a test restore.
I just thought of something else. He's probably using the non-verbose backup option, and our restore option, we haven't given the end user the option of removing verbose. That definitely makes a difference too.
Thanks
Maya
Ps. was McLeod too before I got married, haha