Subject Re: [firebird-support] 10GB FDB Restore (+ index activations) - FB ends up crawling
Author Dimitry Sibiryakov
On 3 Jun 2006 at 10:38, Tom Conlon wrote:

>I've a 10.6GB FDB (made up of 4 long thin tables) and find that
>creating an index takes 3-4 hours+.
>Anybody with any tips would be appreciated.

Play with temporary directories settings. You need very big temp

SY, Dimitry Sibiryakov.