I've just been trying out compression with Firebird 3 rc1. It took a long time to get it working on a Windows 7 64 bit machine until I discovered a post about whether or not zlib should be compiled into Firebird or a separate dll should be used. From that snippet I guessed I needed to download zlib source and compile a 64 bit zlib1.dll as there is no official windows 64 bit zlib1.dll available. Once that was done I could then connect via ISQL using compression, yay!
A little bit more work putting a 32 bit zlib1.dll into the client machine and our Delphi app could connect via compression as well (verified by doing wireshark captures with compression on/off). Looks like great improvements simply going from FB2.5 (protocol 12 I think) to FB3 (protocol13) even before compression is applied! Are the zlib dlls supposed to be included with Firebird or is the documentation supposed to contain a note saying that they need to be obtained separately (or did I just miss this?) Is there any way from a delphi app using ADO to access the database that we can determine if compression is turned on/off? Similarly, is there any way on the firebird server that we can determine if particular clients are operating with network compression? From MON$ATTACHMENTS I can see client version and protocol, just not compression state. Lastly, could the ADO/OLEDB/ODBC connection string contain the parameter for turning compression on/off to easily enable it to be done from within a program when desired? Thanks Mark Kendall Software Engineer [Kinetic ONLY small] Kinetic Engineering Design Ltd PO Box 302-608 North Harbour Auckland 0751 NEW ZEALAND Tel +64 9 968 8368 ext 206 Fax +64 9 968 8365
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
