Subject Re: [ib-support] best tool for remote slow connection
Author Artur Anjos

I agree with you when you say that "most database transmissions are less
then 1K in size, without a lot of repeating..."

We really don't need the lack of compression there. We did not notice that
we are working in a slow connection also. But if you are building a report,
for example, and fetching a lot of data from the server on a slow
connection, compression will be nice. What I was saying that will be nice if
FB could check when or not to compress the data, according to the length of
data to be fetch. That' I'm shure that will make a difference in Slow

I was speaking about encripting at the same time, because if the driver was
changed to use compression, it will be easy also to add encription. I know
that VPN software can do the job, but...

Well, I was just dreaming...


----- Original Message -----
From: "Paul Schmidt" <paul@...>
To: <>
Sent: Monday, October 22, 2001 12:50 PM
Subject: Re: [ib-support] best tool for remote slow connection

> Artur:
> On 19 Oct 2001, at 11:45, Artur Anjos wrote:
> >
> > The problem is not in the tool: you have no way to compress the data
> > in and out of the server.
> >
> > I'd like to see some kind of "compress data" between the server and
> > the client, but I'm not shure if someone on the FB team is working on
> > this.
> >
> > Compressing (and encripting) data is "a must" in this days.
> >
> For compression, you wouldn't gain much anyway, most database
> transmissions are less then 1K in size, without a lot of repeating
> data, what you would gain by compression, you would lose in
> execution time of the compress/decompress execution.
> Compression is most effectiver when used for large, mostly air
> files, for example if you compressed a 1GB .gdb file, because
> index pages are often only half full, it might compress down to 1%
> of it's original size. A 512byte SELECT statement might compress
> to 450 bytes.
> Encryption is far better handled using something like a Virtual
> Private Network, so that a snoop has little or no idea of what your
> actually using. You would have to look, some VPN software might
> offer compression as well.
> Paul
> Paul Schmidt
> Tricat Technologies
> paul@...
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to