| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Israel Ben Guilherme Fonseca <israel(dot)bgf(at)gmail(dot)com>, List <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Incoming/Sent traffic data |
| Date: | 2011-05-12 03:12:48 |
| Message-ID: | 4DCB5030.1020706@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On 05/12/2011 10:45 AM, Israel Ben Guilherme Fonseca wrote:
> Almost difference of received data size is HUGE. Do you guys have any
> idea about what could am I doing wrong? I heard something about binary
> protocol, could it help?
The total size of the transferred data in your tests appears to be tiny.
As a result, you are measuring the connection overhead of the drivers
more than anything else. The JDBC driver will be issuing a lot more SET
statements and the like during connection setup than psycopg2 does. To
see exactly what the differences are, enable full statement logging in
the server so you can see everything that's issued.
Try testing with a meaningful amount of data, or starting measuring only
after you've established a connection.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maciek Sakrejda | 2011-05-12 05:11:02 | Re: Incoming/Sent traffic data |
| Previous Message | Israel Ben Guilherme Fonseca | 2011-05-12 02:45:49 | Incoming/Sent traffic data |