David -
I am not sure that DTS uses compression (as a default). It is noticeable when 10,000+
records are transferred.
There is a good WROX book on DTS programming. You might want to review it. I have not
timed it. Just my impression.
The easiest measure is a stopwatch. If you double the records, does the time double?
If yes, probably no
compression. You should test with a 'doubles' ... sort of plotting a graph. If the
time is less than double, then
it may have compression. Your Network Admin should have a tool. The generic name
escapes me. I recall they are not
cheap.
If you know VB, you can tweak the DTS code.
hth
-brian
David Cummins wrote:
> I'm considering a project where large amounts of data from SQL Server will have
> to be sent from our clients' servers to ours, but I'm worried about the
> bandwidth involved.
>
> Does anybody know what sort of compression DTS uses? (at least I hope it uses
> compression!) Any good tools out there for measuring the network traffic so we
> can test the idea locally?
>
> Cheers,
>
> David
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
