>> You could give the following settings a try:
>>
>> Page Size: 16K
>> Page Buffers: 2048
>> TempCacheLimit in firebird.conf: 134217728
>> LockHashSlots in firebird.conf could be increased as well, e.g: 10009
>
>> Thank you, I give those settings a try. Firstly I need to back up/ restore the DB and it will take a lot of time. I will let know if thigs got better after settings change.

>To speed the process use the -service switch for both backup and restore
>and also -g for the backup to suppress garbage collection in the source
>database while backing up.

And you might do it even faster if you pipe the output of gbak to gbak self, doing a one-pass-backup-restore. Embedded driver will add to the speed :)

gbak.exe -b -user "SYSDBA" -password "masterkey" NAME_OF_DB stdout | gbak.exe -user "SYSDBA" -password "masterkey" -r -buffers 50 -p 4096 stdin NAME_OF_BACKUP
(and using service manager even adds to the speed AFAIK)

Poul Dige
Tabulex