Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group