Subject Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server
Author Alexey Kovyazin
Hi Halim,

firebird-support does not allow attachments. Please put zip with info to
some sharing service like ge.tt, and post link here.

Regards,
Alexey Kovyazin
IBSurgeon


> Please see attached zip file with questionnaire response regarding our server performance.Also, I have attached restore logs from restore using classic server and restore using super server.Please let me know if you have any question.Thank you,-Halim
>
> To: firebird-support@yahoogroups.com
> From: firebird-support@yahoogroups.com
> Date: Sun, 25 May 2014 00:17:21 +0400
> Subject: Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 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@...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo Groups Links
>
>
>