Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

Hi,   test without details say nothing to me 1. Did you compare results with e.g. FB2.5 in on the same maschine with same configuration (FBConfig) 2. What is your page size and type of HDD? 3. Do you have BOST feature enabled on CPU and HT? 4. Did you compare results on GLOBAL TEMPORARY TABLE - i

[firebird-support] performance issue with firebird 3.0 embedded on linux

Hi there, Recently I am doing some performance test on firebird 3.0 embedded used in my project. The test is pretty straightforward, on one same table, use 100 insertions per transaction as base test unit (creating a transaction, using a loop to insert 100 records, and committing the

Re: [firebird-support] Engine12 mistery

Mark Thank you, I think I am beggining to understand the concept, so the provider's have to be combined including ALWAYS Engine12 (the core FB server procedure/method that really goes to the file on disk and does the reading and writting to the DB). So the following combinations are valid:

Re: [firebird-support] Engine12 mistery

On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support] wrote: > My understanding from reading the documentation is: > > Provider = Remote means the client is on the network, excluding > 127.0.0.1 > Provider = Loopback means the client is actually on the same OS > instance as the

Re: [firebird-support] Engine12 mistery

My understanding from reading the documentation is: Provider = Remote means the client is on the network, excluding 127.0.0.1 Provider = Loopback means the client is actually on the same OS instance as the FB3 engine, and it is using the 127.0.0.1 to access the database to avoid the "embedded

Re: [firebird-support] Engine12 mistery

14.06.2016 19:56, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] wrote: > Is there a reason why the FB 3 server configured as follows would require > Engine12 as a > provider? Because it is server. The configuration is enough for Firebird client, but server needs engine to work

Re: [firebird-support] Engine12 mistery

Engine12 is actually the post of Firebird 3 that is the implementation of the database server (and understands ODS12). So it is a required part of Firebird 3. Mark - Bericht beantwoorden - Van: "fabia...@itbizolutions.com.au [firebird-support]" Aan:

[firebird-support] Engine12 mistery

Hi All, Is there a reason why the FB 3 server configured as follows would require Engine12 as a provider? DatabaseAccess = None AuthServer = Srp AuthClient = Srp UserManager = Srp Providers = Remote WireCrypt = Enabled WireCompression = false ServerMode = Super I've noticed the

[firebird-support] Re: FB3 - Is RemoteBindAddress a Serverwide variable or a Database linked variable?

14.06.2016 15:52, fabia...@itbizolutions.com.au wrote: > 1) The variable "RemoteBindAddress" in firebird.conf is a Server Wide > value, or it can be set per database in databases.conf? Server wide. Dmitry

Re: [firebird-support] FB3 - Is RemoteBindAddress a Serverwide variable or a Database linked variable?

I'll answer myself for 2) 2) page 42 of http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf 1) and 3) remain a question Cheers Fabian - Original Message - From: fabia...@itbizolutions.com.au [firebird-support] To:

[firebird-support] FB3 - Is RemoteBindAddress a Serverwide variable or a Database linked variable?

Now that I have the production candidate FB 3 server up and running I am doing some fine tunning, and there a few questions I'd like to ask: 1) The variable "RemoteBindAddress" in firebird.conf is a Server Wide value, or it can be set per database in databases.conf? 2) The "WireCompression"

Re: [firebird-support] FB 3 - Adding anew User

Hi Thomas, I understand, I think I've done it 3 times before adding the password at the end, I will try the hole thing again in a new environment and come back with the log so we are sure we got this on nailed down. Cheers, Fabian - Original Message - From: 'Thomas Steinmaurer'

Re: [firebird-support] FB 3 - Adding anew User

Hi Helen I understand, I have read the comments, we are reffering to two different things, I mean the sentence in step 2) not further ahead, the sentence as placed on the Release Notes to execute the isql program fails to execute unless it contains the passowrd. What I am referring to is

Re: [firebird-support] FB 3 - Adding anew User

Hello Fabian, > Sorted after reading "Initializing the Security Database" from > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf > at page 116. I think there is a small error on the documentation, where it > says > " isql -user sysdba employee", the