Tim

I've read some threads about RemoteCompression and perform some tests to see
if it helps or not and saw some signficant improvements.

RemoteCompression = 0 x RemoteCompression = 6

When I use 6 (compressed) I run the same query 20 times and after that I run
the same query 20 times again. Then I close the app and restart with no
compression and then the compression version. Every time I take a note of
ExecutionTime.

My doubt: My tests show me the compression speed up the app but I want to
hear you about it. Is there any situation that it is not true ?

I will apreciate any comments about it (from users that is already using
RemoteCompression).

Eduardo

Jose Eduardo Helminsky wrote:
....
> My doubt: My tests show me the compression speed up the app but I
> want to hear you about it. Is there any situation that it is not true
> ?

Yes: when transporting the data is faster than compressing and uncompressing
them. On a GBit line, I would not use compression. Better to use the CPU
cycles to run the statements even faster.

Ralf

Ralf,

<< Yes: when transporting the data is faster than compressing and
uncompressing them. On a GBit line, I would not use compression. Better to
use the CPU cycles to run the statements even faster. >>

Exactly what I would have said, but in less words and in a more
understandable fashion.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> Ralf,
>
> << Yes: when transporting the data is faster than compressing and
> uncompressing them. On a GBit line, I would not use compression.
> Better to use the CPU cycles to run the statements even faster. >>
>
> Exactly what I would have said, but in less words and in a more
> understandable fashion.

If you want to tell me that I am babbling and should try to express myself
more clearly - you are right

Ralf

Ralf


I think Tim was accusing himself of being the babbling one

Roy Lambert

Roy,

<< I think Tim was accusing himself of being the babbling one >>

Correct.  Sometimes I leave out the most important items also.

--
Tim Young
Elevate Software
www.elevatesoft.com