Re: Incoming/Sent traffic data

Поиск
Список
Период
Сортировка
От Israel Ben Guilherme Fonseca
Тема Re: Incoming/Sent traffic data
Дата
Msg-id BANLkTi=BFLrc+-fT5ggYM1E33wvobDr5zA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Incoming/Sent traffic data  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: Incoming/Sent traffic data  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Well, I'm suspicious too. :)

The logs that I pasted in the previous mail was with debug5, but you mean the client driver itself? I'll give a look.

About the wireshark itself, in the link that I pasted, I put 2 screenshots about the measure, at a gross look at it, You can easily tell that the packages are somewhat different.

The java hava a lot of /D/D/D/D

Maybe it's about this:

http://developer.postgresql.org/pgdocs/postgres/protocol-error-fields.html

2011/5/13 Oliver Jowett <oliver@opencloud.com>
On 13 May 2011 16:38, Israel Ben Guilherme Fonseca <israel.bgf@gmail.com> wrote:
>> +1 too. I just asked because its common to get shot at mailists after a
>> little of 'off-topic'.
>
> Well afters tons of tests, using my brand new Wireshark skills (thanks
> Maciek), and I got a very strange result (even stranger than before):
>
> I created a new database for the tests, 1 'Person' table, 2 columns (id,
> name), 7000++ registers.
>
> The traffic difference was:
>
> Java     220861 Bytes
> Python 29014 Bytes

Well, your next step should be compare the two wireshark captures and
see what's being done differently in the two cases.
You can run the JDBC driver with loglevel=2 and it'll tell you what it
is doing, too. But really, if what you care about is what's on the
network, then wireshark is the right tool for that job.

I would be suspicious of your Python measurements, FWIW. 29kB for 7k
rows implies you're only receiving ~4 bytes per row, which seems far
too low.

Oliver

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Incoming/Sent traffic data
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Incoming/Sent traffic data