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: [email protected] From: [email protected] 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: [email protected] From: [email protected] 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 [email protected] [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:[email protected] [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
