Subject Re: gbak takes days to restore large db?
Author dbambo2000
--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
> dbambo2000 wrote:
> > Aage,
> > Thanks for responding. I'm using Firebird 1.5. The page size is
> > 8192. I'm not sure about the number of cache pages. I don't think
> > I've altered this from the default setting. Would that be an issue?
> > dbambo2000
>
> I don't think so, but then I never experimented much. I usually use
around
> 8K pages (of 8KB, sometimes less). Tried once with 40.000 (on
IB/5). Only
> once.
> Your cpu speed is probably ok, but what about disk speed on the
WinXP (may
> be slowish on some laptops, I think). What about fragmention?
> Are the temp area on the same disk as the database?
>
> Is it still running? If you stopped it, you could restart using the -v
> switch to see what activity is slow.
>
> --
> Aage J.
> [Top-posting makes for difficult reading...]
>


Aage,
After 30 or more hours it was at about 7 gigabytes restored (out of
15). Since I had mistakenly connected to the db while the restore was
happening and I wasn't sure if I might have corrupted it, I decided to
stop it and restart (as you suggested) with the verbose option. I
also defragmented the disk first in case that was a factor.

Thanks for you input.