Re: Incoming/Sent traffic data

On Fri, 2011-05-13 at 13:40 -0300, Israel Ben Guilherme Fonseca wrote:
> Well I finally figure it out thanks to you guys.
>
> After checking the package contents I could notice that the Java test
> I can easily see it contents (traffic data and select statements).
> That wasn't true for the Python test, the content show as a bizarre
> sequence o characters.
>
> So as you guys argued, it was indeed ssl encrypted. I checked the docs
> and learned how to disable it and I got the same results as the java
> driver.
>
> 221222KB (almost the same)
>
> But here is the question, does the SSL compress the data too?

http://httpd.apache.org/docs/2.0/ssl/ssl_faq.html#comp

and postgresql and libpq use OpenSSL, so depending on version of SSL
used, you may get the compression part automatically

JDBC's SSL support may no (yet) include it

> I enabled the self-signed ssl mode for the java test, and It was
> indeed encrypted, but the traffic was still "big", differently to the
> python version.
>
> Any Ideas?
>
> (i'm doing this question on the psycopg2 mailist too)
>
> Thank you guys again for the help.
>
> 2011/5/13 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
> Maciek Sakrejda <msakrejda(at)truviso(dot)com> wrote:
>
> >> D is just a DataRow message, you get one of those per row
> >> returned.
>
>
> > Right. If you're *not* getting those in Python, you're not
> getting
> > the data, so something is seriously wrong there.
>
>
> Perhaps python doesn't ship all the rows back on execute, but
> waits
> for the rows to be requested? If it isn't already doing it,
> try
> changing the script to read all the rows in the result set.
>
> -Kevin
>

--
-------
Hannu Krosing
PostgreSQL Infinite Scalability and Performance Consultant
PG Admin Book: http://www.2ndQuadrant.com/books/