Subject Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server
Author Alexey Kovyazin
Post date 2014-05-24T20:17:21Z
Hi,

In order to give you a good optimization advice, please answer the following questions:
http://ib-aid.com/en/articles/required-information-for-firebird-database-performance-optimization/

Regards,
Alexey Kovyazin
IBSurgeon



 

Thank you for your reply. 
I used default restore settings and I got over 8 hours of restore time. Increasing the cache size using gfix -b did not help at all. I got the same result. I don't think it helps during the restore process.
-Halim

To: firebird-support@yahoogroups.com
From: firebird-support@yahoogroups.com
Date: Sat, 24 May 2014 09:28:01 +0200
Subject: Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

 
Guten Tag halim1973@... [firebird-support],

much toooooo few information for any reasonable answer, so just the standart

Cache settings ? ar way too low in staddart classic setup
try increasing them

> Hello All,

> Our database is about 30 GB. We are using Firebird 1.5. When restoring the database using Super server install, the restore takes about 2.5 Hours but when we use Classic Server mode, the restore takes over 8 hours.

> Our machine is up to date as far as CPU and RAM(64 GB ).

> Any idea why this difference of restore speed?

> Thank you,

> -Halim
>
>
>
>

--
Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...