I do recall that it took a few minutes to transfer 120,000 records via DTS over
ADSL, but I appreciate that the scientific approach might be in order. Choose
easily compressed data (i.e. all the same) and do the doubling thing.
Do you recall the name of the book? Another thing on the wishlist would be if
the book had information on the DTS file format, because the Enterprise Manager
interface leaves a lot to be desired...
Unfortunately we're fresh out of Network Admins right now, so I guess that
option is out then. ;)
Is DTS implemented in VB, or is there just some sort of API for it? Where would
one find the source?
Cheers,
David
Brian Hogue wrote:
>
> 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
