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 m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote: On 4-3-2019 10:06, 'Mr. John' mr_joh...@yahoo.com [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