Subject Re: [firebird-support] Turn on WireCompression on Firebird 3
Author Mr. John
got "WI-V3.0.4.33054 Firebird 3.0/tcp (WIN-CNVKF3V883H)/P13:Z",so compression is enabled

there other server tweaks to improve the performance for my case?

thanks


On Monday, March 4, 2019, 11:12:45 AM GMT+2, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


 

On 4-3-2019 10:06, 'Mr. John' mr_johnmr@... [firebird-support] wrote:
> I'm using latest version 6.5.0
> found no isc_database_info item isc_info_firebird_version;
> in FbConnection.ServerVersion.

That is not what I meant... The request to Firebird server is done using
the isc_database_info operation, requesting information item
isc_info_firebird_version. This is done behind the surface by the
Firebird ADO.net provider when it opens a connection. The value is
returned from the property ServerVersion of your connection.

For example the code on my machine prints "WI-V3.0.4.33054 Firebird
3.0/tcp (Ramona)/P13:Z" which means compression is enabled:

var connectionString = new FbConnectionStringBuilder
{
Database = @"D:\data\db\fb3\fb3testdatabase.fdb",
UserID = "sysdba",
Password = "masterkey",
Compression = true
}.ToString();

using (var connection = new FbConnection(connectionString))
{
connection.Open();
Console.WriteLine(connection.ServerVersion);
}

Mark

--
Mark Rotteveel