|Subject||Re: [ib-support] best tool for remote slow connection|
On 19 Oct 2001, at 11:45, Artur Anjos wrote:
> A REMOTE ULTRA HIGH PERFORMANCE CONNECTION to FB? :)
> 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
> 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.