Re: [firebird-support] Restore performance (gbak service_mgr) whilst activating indices

2017-09-12 Thread s3057...@yahoo.com [firebird-support]
Hello Group, Here is some further information that might be of interest. I created a 10GB test table database with a big for loop in an exec block statement with various indices, however interestingly this database did not exhibit the same "go slow" behaviour. What I mean by that is that obviou

Re: [firebird-support] Restore performance (gbak service_mgr) whilst activating indices

2017-09-08 Thread s3057...@yahoo.com [firebird-support]
Hello Thomas, Thank you for your reply. The VM I was using only has one core allocated to it. It was definitely CPU bound for part of the time (as expected), but there were substantial portions of time where the 1 CPU core was under 5% utilisation and the I/O should have had plenty of headroom.

Re: [firebird-support] Restore performance (gbak service_mgr) whilst activating indices

2017-09-07 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Hello Group, > > Sorry if this double posts, I received an error when Sending. > > I was provided with a largish (~27GB) Firebird 2.5 backup file (gbak) > yesterday. I have been restoring this on Windows 2012R2 running 2.5.6 Classic > using gbak with the -service_mgr switch. This particular VM

[firebird-support] Restore performance (gbak service_mgr) whilst activating indices

2017-09-07 Thread s3057...@yahoo.com [firebird-support]
Hello Group, Sorry if this double posts, I received an error when Sending. I was provided with a largish (~27GB) Firebird 2.5 backup file (gbak) yesterday. I have been restoring this on Windows 2012R2 running 2.5.6 Classic using gbak with the -service_mgr switch. This particular VM only has a s