Instance Encoding Option
The Instance Encoding Option property of the SQL Workflow Instance Store lets you specify whether the SQL persistence provider should compress the workflow instance state information using the GZip algorithm before saving the information into the persistence database. The allowed values for this property are: GZip and None. The default value is None. The following list describes these options.
GZip. The persistence provider encodes the state information using the GZip algorithm before persisting the state information in the persistence database.
None. The persistence provider does not encode the state information before saving the information into the persistence database.
Encoding workflow instance state information using the GZip reduces memory consumption in the SQL database and also reduces network consumption if the database resides on a different computer on the network from the computer on which the workflow service host is running. A general guidance is to set the Instance Encoding Option property to None if the workflow instance state is small.
