Sage 100

Does anyone know how to use the "Use Compression" option in the ProvideX ODBC Driver setup? Other than enabling this option (which seems to degrade performance substantially with C/S on both the server and workstation) I do not see any other control. I would expect there would be a control on both ends of the connection, but I am not seeing anything on the server side (advanced versions 2020 or 2019).


ZLib is a compression method with roots similar to the PNG format (i.e. gzip). I have been unable to locate any usage documentation on the partner site, here on 90Minds.com or the Sage Community that references it.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-224-6642
------------------------------

That setting is news to me.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

I am not sure about this but I believe the compression only works when using CS ODBC to communicate. When turned on it would send the request to the server for data and the server will see the flag on and compress the data when it sends it to the client. There is no configuration other than turning it on or off from the client. The only thing you would see on the server is the CS ODBC server side running as a service. I would expect a performance hit on the server and client to compress and decompress. I would only set if your bandwidth is too small but your machines are beefy. 

This isn't specific to ODBC but this is the function in PxPlus to compress CMP() and then there is a decompress UCP() . This uses zLib. Not sure if it helps answer your question but at least you can see how the sample code uses the function to compress. 
https://manual.pvxplus.com/PXPLUS/functions/cmp.htm

If you are looking how to set things like Z_Best_Speed or Z_Best_Compression I don't think those are configurable and are preset. ProvideX has built-in support for ZLIb but references to it in the manual indicate you can in some places turn it on or off and that is about it from what I can find.

------------------------------
Todd Martin - President
MBA Business Software (https://www.mbabsi.com)
------------------------------