Just for a bit of closure with this one, I found that the page size on
restore (gbak -r -p <n> ....) can dramatically affect the time taken to
restore a backup. On a 3.2G database restore times with different page
sizes were:
1k -> 196 mins
4k -> 84 mins
8k -> 73 mins
16k -> 65 mins

I believe 1k is the default with 1.0.3, or at least that's what it is on
our gdb under Linux.

Cheers.


Bradley Tate wrote:

> Hi,
>
> I'm having a problem with unacceptably long restore times on a large
> (3Gig+) Firebird 1.0.3 database on linux. I do a gbak backup which takes
> about 15 minutes and then a restore which takes over 3 hours. This is on
> a box with no other users, adequate disk space and 1G RAM.
>
> Not that long ago the restore used to take a little over 1 hour, which
> is acceptable for our needs. Has anyone seen this type of behaviour
> before where restore times blow out? Others have had admin access so I
> can't be certain nothing has been changed i.e. a few indexes could have
> been added but nothing I can find to account for a 3 x increase in
> restore time.
>
> Any advice or suggestions gratefully received.
>
> Thanks in advance.
> B.
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>