Re: compress a resultset - Mailing list pgsql-jdbc

From Roland Walter
Subject Re: compress a resultset
Date
Msg-id 44FDE03F.1000804@gmx.net
Whole thread Raw
In response to compress a resultset  (Andreas Reichel <andreas.reichel@beratung-studienkredit.de>)
List pgsql-jdbc
-----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-----

pgsql-jdbc by date:

Previous
From: Matt Chambers
Date:
Subject: Re: jdbc3, pg 8.1.4 , and stored procedures
Next
From: Matt Chambers
Date:
Subject: scollable result sets