Subject | Re: gbak takes days to restore large db? |
---|---|
Author | dbambo2000 |
Post date | 2005-07-24T13:45:36Z |
--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
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.
wrote:
> dbambo2000 wrote:around
> > 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
> 8K pages (of 8KB, sometimes less). Tried once with 40.000 (onIB/5). Only
> once.WinXP (may
> Your cpu speed is probably ok, but what about disk speed on the
> be slowish on some laptops, I think). What about fragmention?Aage,
> 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...]
>
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.