Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
>i > >> * How does your gbak restore call look like? >> GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk >> "LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb" -v -rep -o >> -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y "G:\FBDump\ >> ;RestoreEasyPos.txt" >> >> At 09:03 a.m. 18/11/2014

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread Robert martin r...@chreos.com [firebird-support]
i > * How does your gbak restore call look like? > GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk > "LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb" -v -rep -o > -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y "G:\FBDump\ > ;RestoreEasyPos.txt" > > Have you tried it with the -G fla

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello Michael, > Beside your gbak restore issue, your counters here show some interesting > throughput numbers, when taking the creation date of the database into > account: > > ~ 170 transactions / sec > ~ 9 connections / sec > > > > > We have a external connection from a WEBStore. > Whate

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread michael.vilhelm...@microcom.dk [firebird-support]
Hmmm, database dialect is 1. No, not really. It was originally created as Dialect 1 back in 1998. It has never been changed, it works and as a matter of fact I'm not sure what happens if the dialect is changed...

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hmmm, database dialect is 1. No issues with that? Greetings. Walter. On Mon, Nov 17, 2014 at 7:41 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > > > > Isnt the transaction per second wrongly calculated? > > Oops, sorry!!! I have been one year off by using 2014

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Isnt the transaction per second wrongly calculated? Oops, sorry!!! I have been one year off by using 2014 instead of 2013. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread michael.vilhelm...@microcom.dk [firebird-support]
Isnt the transaction per second wrongly calculated? DB is created november 2013. Approcimatly 365 days ago. Transaction is at 96.356.705. Per day is approx: 263.990 Per hour: 10.999 Per minut: 183. Per second: 3

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread michael.vilhelm...@microcom.dk [firebird-support]
Beside your gbak restore issue, your counters here show some interesting throughput numbers, when taking the creation date of the database into account: ~ 170 transactions / sec ~ 9 connections / sec We have a external connection from a WEBStore. Whatever they do, they connect and discon

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello Michael, > * What is the page buffers value at database level? (gstat -h) > E:\DB\Kaufmann>"c:\Program Files\Firebird\Firebird_2_5\bin\gstat.exe" > localhost: > e:\db\Kaufmann\OCCEasyPos.FDB -h > > > Database "e:\db\Kaufmann\OCCEasyPos.FDB" > Database header page information: > Fla

[firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

2014-11-17 Thread michael.vilhelm...@microcom.dk [firebird-support]
* What is the page buffers value at database level? (gstat -h) E:\DB\Kaufmann>"c:\Program Files\Firebird\Firebird_2_5\bin\gstat.exe" localhost: e:\db\Kaufmann\OCCEasyPos.FDB -h Database "e:\db\Kaufmann\OCCEasyPos.FDB" Database header page information: Flags 0