Subject | Backup much faster than restore |
---|---|
Author | Maya Opperman |
Post date | 2013-05-08T06:18:21Z |
Hi,
Got an interesting question from one of my customers:
"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
[Non-text portions of this message have been removed]
Got an interesting question from one of my customers:
"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
[Non-text portions of this message have been removed]