Re: jdbc driver performance TODO

From: Kris Jurka <books(at)ejurka(dot)com>
To: Julien Patrouix <jpatroui(at)genoscope(dot)cns(dot)fr>
Cc: Bucky Jordan <bjordan(at)lumeta(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jdbc driver performance TODO
Date: 2006-10-29 02:23:27
Message-ID: Pine.BSO.4.63.0610282120420.1994@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Sat, 28 Oct 2006, Julien Patrouix wrote:

> In my opinion, improvements could be made in the encoding/decoding of the
> protocole messages (Ie the PGStream class).
> From what I have seen thanks to a profiler some methods are over invoked, and
> the numeric encoding is not as efficient as it could be.
> That numeric encoding/decoding is used very often, even for the protocole
> purposes, not only for data encoding.
>
> Furthermore, it would be interesting not to use the java BufferedStream
> implementation, and use a specific one so as to directly manage and access
> the buffer.

This is what Mikko Tiihonen has done here and I intend to apply it next
week. http://archives.postgresql.org/pgsql-jdbc/2006-09/msg00163.php

> I use a driver I have optimized, and submitted these obervations a couple of
> time to the list, but I'm really sorry I can't contribute more for a long
> time I'm afraid

I've never seen a patch come across this list. Could you retry or point
me to an archives entry?

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-10-29 02:50:59 Re: JDBC CTS failures
Previous Message Kris Jurka 2006-10-29 02:19:12 Re: Prepared statement vs. parameterized