|Subject||RE: [firebird-support] 10GB FDB Restore (+ index activations) - FB ends up crawling|
> Hi All,what's the page size? have you tried different page sizes?
> I've a 10.6GB FDB (made up of 4 long thin tables) and find that
> creating an index takes 3-4 hours+.
> During the latter stages of a restore similar effects occur.
> After a certain period (appears to be in last 1/4 of restore/index
> creation) At this time the CPU usage is very low and the FDB is
> growing very very slowly. There is more than sufficient disk space.
> Anybody with any tips would be appreciated.