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


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/