Page 1 of 1
using encryption and compression
Posted: Thu 25 Mar 2010 10:48
by brace
Is it possible to compress data when sent across the network together with encryption?
THe idea is to minimize network traffic.
Posted: Thu 25 Mar 2010 13:49
by Dimon
SQL Server doesn't support compressing of transferred data.
SDAC allows to compress blobs only. For more detailed information see the TCompressedBlob class description in the SDAC help.
Posted: Fri 02 Apr 2010 11:05
by brace
There are no info on CompressBlobMode for TMSQuery
ms-help://embarcadero.rs2009/Devart.Sdac/Sdac/Devart.Sdac.TCustomMSDataSet.Options.htm
Anyway i tired to run a query on a table that contains one blob field and if CompressBlobMode is cbClient or CBClientServer the query opens 3 times slower, while I was expecting the opposite.
Why?
Posted: Tue 06 Apr 2010 06:49
by Dimon
Data compressing is effective in case of slow network, where capacity of transferred data has critical meaning. In network with high speed of data transferring (for example in local network), application works more slowly when data compressing is used, because time is spent on data compressing/decompressing.