Compressing FetchWhere data output

spoudret

My requirements demands that I query some table many times an hour using the fetchwhere API. 

The downloading of the query's output takes a certain toll on our bandwidth, and the download time itself does not help either.

I am aware that some APIs allow for on-the-fly  gzio compression to achieve a faster overall transfer rate.  Is it possible to do the same with the fetchwhere output?

TIA,

Stephen

Legacy Contributor

Not that I can see.  I am using FetchWhere in SSIS and getting the new records using transdttmz and merging them.  Most of the calls take under a minute.