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

    
  • [firebi... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
    • Re... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
    • OD... Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
      • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
              • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
              • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
                • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
                • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]

Reply via email to