I am using Lazarus 1.8.4 in Windows and Linux with Firebird 3.0.3.
Firebird 3 supports WireCompression and I have set it enabled in server side via firebird.conf.
To connect to Firebird, I am using TSQLConnector/TIBConnection.
Is Lazarus supports WireCompression? If so, how to set it? I didn't see any property to set it in TSQLConnector /TIBConnection.
1. Library zlib1 must be installed on your server.
2. Set parameter in firebird.conf or databases.conf, on server side:
WireCompression=true
3. fbclient.dll and zlib1.dll must be of same bitness (32 or 64) of your binary, both must be on the same directory of your binary, on client side.
4. Create a firebird.conf with parameter WireCompression=true. Put this file on the same directory of your binary.
5. For future versions of Lazarus only, you can set the connection param:
IBConnection1.Params.Add('wirecompression=true');
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk02ch06s06.html----------------
WireCompression
Alex Peshkov
Parameter in firebird.conf or databases.conf, enabling or disabling compression of data over the wire at global or individual database level.
The default setting is disabled (= False). Settings and environment must be correct at both server and client for WireCompression to take effect:
To enable it at the server side, in firebird.conf and/or databases.conf, change the setting to True
To activate Wirecompression from the client side, pass the appropriate tag in the config item of the DPB or SPB call:
isc_dbp_config/isc_sbp_config <string-length> "WireCompression=true"
Both server and client versions must be Firebird 3 or greater (protocol >=13)
----------------