From: | Roland Walter <roland(dot)walter(dot)rwa(at)gmx(dot)net> |
---|---|
To: | andreas(dot)reichel(at)sachsenlb(dot)de |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: compress a resultset |
Date: | 2006-09-05 20:38:23 |
Message-ID: | 44FDE03F.1000804@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)walter(dot)rwa(at)gmx(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Chambers | 2006-09-05 21:16:30 | scollable result sets |
Previous Message | Matt Chambers | 2006-09-05 19:18:59 | Re: jdbc3, pg 8.1.4 , and stored procedures |