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

2015-05-27 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: Odp: [firebird-support] Database restore speed with IBExpert and Gbak Data: śr., maj 27, 2015 09:58 ---In firebird-support@yahoogroups.com, ts@... wrote : From a throughput perspective, this would mean: IB XE3 = 0,918 MB/s IB XE7 = 1,896

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

2015-05-27 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
@yahoogroups.com Temat: [firebird-support] Database restore speed with IBExpert and Gbak Data: wt., maj 26, 2015 19:02 Hello Walter, Hello Thomas That seems an interesting idea. Can you explain it with more details? For the restore process, gbak supports a -BU(FFERS) switch

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

2015-05-27 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, ts@... wrote : From a throughput perspective, this would mean: IB XE3 = 0,918 MB/s IB XE7 = 1,896 MB/s FB 3 = 3,282 MB/s To be honest, astonishing low numbers in 2015, for all three. To be even more honest, measure time of restore without

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

2015-05-27 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
---In firebird-support@yahoogroups.com, ts@... wrote : From a throughput perspective, this would mean: IB XE3 = 0,918 MB/s IB XE7 = 1,896 MB/s FB 3 = 3,282 MB/s To be honest, astonishing low numbers in 2015, for all three. To be even more honest, measure time of restore without

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

2015-05-26 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Thank you very much, Thomas. Very useful. Greetings. Walter. On Tue, May 26, 2015 at 1:02 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com wrote: Hello Walter, Hello Thomas That seems an interesting idea. Can you explain it with more

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

2015-05-26 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
IB XE7 - 45 minutes FB 3- 26 minutes Regards, Karol Bieniaszewski - Reply message - Od: Thomas Steinmaurer t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Database restore speed with IBExpert and Gbak

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

2015-05-26 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Halim, 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

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

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

2015-05-26 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Thomas That seems an interesting idea. Can you explain it with more details? Greetings. Walter. On Tue, May 26, 2015 at 12:25 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com wrote: Halim, Thank you for your reply. I just tested a

[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

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

2015-05-26 Thread 'Thomas Steinmaurer' t...@iblogmanager.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

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

2015-05-26 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello Walter, Hello Thomas That seems an interesting idea. Can you explain it with more details? For the restore process, gbak supports a -BU(FFERS) switch to override the database page buffer value. While page buffers tends to be rather small for Classic/SuperClassic hosted databases, you