Обсуждение: compress a resultset

good morning,

from a database with stock related data i query large resultsets. The
database performes well, but the transfer over the dial-up connection is
very slow.

Now i'd like to ask, if there is any solution to compress the resultset
on the server and decompress it after the transfer then. Perhaps there
is something like

props.setProperty("data compression","true");

or

props.setProperty("compress","true");

Thank you very much in advance for any hint. Best regards
Andreas

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andreas Reichel schrieb:
> good morning,

Hello Andreas!

>
> from a database with stock related data i query large resultsets. The
> database performes well, but the transfer over the dial-up connection is
> very slow.
>
> Now i'd like to ask, if there is any solution to compress the resultset
> on the server and decompress it after the transfer then. Perhaps there
> is something like
>
> props.setProperty("data compression","true");
>
> or
>
> props.setProperty("compress","true");
>

I do not know of such an extension to the server. You may try to tunnel
the connection via SSH. SSH has a switch for compressing the data stream.

Regards,
Roland.

- --
Dipl.-Phys. Roland Walter    phone:  +49 2238 462163
Römerfeldstr. 8              mobile: +49 177 2373036
50259 Pulheim                mailto: roland.walter.rwa@gmx.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFE/eA/xoOEAkary1ERAjqYAJ0WCofKgzR1ctfN8OyXlc0zJHH93QCfeeGP
9aA+0ULTqBzCkgeLzKmmdx0=
=8gCJ
-----END PGP SIGNATURE-----