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...]

>
> --- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
> wrote:
>
>>dbambo2000 wrote:
>> > Hello,
>> > I am attempting to restore a 15GB database (containing 18 thousand
>> > tables) from a remote Win2003 server to my local WinXP Pro Pentium 4
>> > system with 768MB Ram. I began the restore about 20 hours ago and
>> > thus far it has restored about 5.7 gigabytes. At this rate it will
>> > take a few days to complete the restore. Is this normal? Can I do
>> > anything to speed things up?
>> > I understand that gbak creates indexes during the restore and that
>> > this contributes to the time required to complete the process.
>>
>>18.000 tables? (amazed!)
>>
>>If you use the -v switch on gbak you'll see what it is doing (restoring
>>records or building indexes or whatever. Not much details, though).
>>
>>Which version og Fb (or IB)? Fb/1.5 is a lot quicker than previous
>>versions (in my experience). It also depends on indexes and h/w. I'm
>>restoring 1.5GB in about 3/4 of an hour (2x 3GHz XEONs and 15krpm
>>disks). I think Fb/1.0 needed 4+ hours (on <1GHz cpus)
>>What page size and no. of cache pages do you use?
>>
>>
>> > Also, while running the restore, I mistakenly connected to the
>> > database from IB Manager. I didn't open any tables or modify any
>> > data. I only made the connection to the db and then immediately
>> > closed the connection. Could doing so have corrupted the
>
> restore? If
>
>> > so, would it have said so via some error message immediately at the
>> > command line prompt where the gbak command was initialized? Nothing
>> > has changed at the command line prompt. The gbak command was not run
>> > with the verbose option enabled.
>>
>>Is has been mentioned that this can be a cause of corruption. However,
>>I've tried this (on pre-Fb/1.5) and did not notice any negatives.
>>You'll have to test after the restore has finished...
>>
>>
>>You should look forward to Nbackup :-/
>>
>>
>>--
>>Aage J.
>