Hi Halim,
Try to use optimized configuration file for Firebird 1.5 Classic:
http://ib-aid.com/optimized-firebird-configuration
Regards,
Alexey Kovyazin
IBSurgeon
Here is the link to the zip file: http://ge.tt/1raCY2i1/v/0?c
Thank you,
-Halim
> To: firebird-support@yahoogroups.com
> From: firebird-support@yahoogroups.com
> Date: Tue, 27 May 2014 21:30:03 +0400
> Subject: Re: [firebird-support] Restore DB with Firebird 1.5 Super
Server vs Classic Server
>
> 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
> > halim1...@yahoo.com [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:hstreic...@gmx.de
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [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
> >
> >
> >
>
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
