[firebird-support] Re: Database restore speed with IBExpert and Gbak

2015-05-26 Thread halim1...@hotmail.com [firebird-support]
Thank you for sharing this knowledge with us. Very good things to learn. -Halim

Re: [firebird-support] Database restore speed with IBExpert and Gbak

2015-05-26 Thread halim1...@hotmail.com [firebird-support]
Thank you for your reply. I just tested a GBAK restore using -se(rvice) switch on a 1 GB DB. It took about 8 minutes. Restoring the same database using IBExpert took about 3 minutes. I'm looking for a faster restore time because I want to automate the process using a batch file. Our DB is over

[firebird-support] Database restore speed with IBExpert and Gbak

2015-05-26 Thread halim1...@hotmail.com [firebird-support]
Hello all, I came across something really strange as far as restoring a Firebird database. if I use IBExpert(a tool from HK Software) it takes about 3 hours but if I use regular gbak using command line it takes 9 to 10 hours. I'm using Firebird 1.5. IBExpert vesion 2008.08.08 I think I'm missi

Re: [firebird-support] FB 1.5 server sluggish after been up for awhile

2015-05-24 Thread halim1...@hotmail.com [firebird-support]
Thank you for your reply. Here is what I got after running gstat -h before and after backup restore. Before backup/restore Database "d:\data\POS\cfbdbcopy.fdb" Database header page information: Flags 0 Checksum 12345 Generation 31599023 Page size 8192 ODS version 10.1 Oldest trans

[firebird-support] FB 1.5 server sluggish after been up for awhile

2015-05-23 Thread halim1...@hotmail.com [firebird-support]
Hello All, we are still on FB 1.5 release, our live Database is about 50 GB. While using the freshly restored database, things are very fast in the beginning but they get slower and slower as weeks go by. We are always forced to do a backup/restore after 4 weeks or so. In the beginning we were

RE: [firebird-support] FB database Replication

2014-06-03 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
At 01:36 p.m. 2/06/2014, halim1...@hotmail.com [firebird-support] wrote: >Hello All, >I was looking for a good replication tool to replicate our FB database. I came >across FBReplicator from IBPhoenix. The tools is not that simple to setup but >it works good if setup properly

[firebird-support] FB database Replication

2014-06-01 Thread halim1...@hotmail.com [firebird-support]
Hello All, I was looking for a good replication tool to replicate our FB database. I came across FBReplicator from IBPhoenix. The tools is not that simple to setup but it works good if setup properly. The only question I have regarding this tool is whether it allows metadata replication or not.

RE: RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-06-01 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Thank you Josh,We are dealing with your old issue now. we upgraded from 2003 32 bit to win 2008 server 64 bit. We have two servers. Our plan is to downgrade one server to 2003 32 bit and use it for now. The second server will remain on win 2008. We will install FB 2.5.2 on it and test our apps

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
it? Regards, Alexey Kovyazin IBSurgeon 30.05.2014 4:41 пользователь "halim1...@hotmail.com [firebird-support]"

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
IBSurgeon 30.05.2014 4:41 пользователь "halim1...@hotmail.com [firebird-support]" написал: We recently upgraded our database server from Win server 2003 to Win 2008 server. We upgraded hardware as well. The new hardware (IBM x3550

[firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-29 Thread halim1...@hotmail.com [firebird-support]
We recently upgraded our database server from Win server 2003 to Win 2008 server. We upgraded hardware as well. The new hardware (IBM x3550 M4) is way more advanced than the old one. 4 times the RAM and CPU speed. We ran some tests on the new hardware(a few select/update queries), the performa

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
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 >

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
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: f

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
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-sup