JDBC Binary transfer of Arrays

From: bubba postgres <bubba(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: JDBC Binary transfer of Arrays
Date: 2011-04-01 03:04:39
Message-ID: AANLkTikLWjP8e=QAYCt+tnB7J9XJVRXZyMSF4_6hoC1=@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!
In my current application I am sending a lot of data to/from the DB with
JDBC, and specifically arrays of Double. (or even Double[][]).
Alas, my current implementation I converts everything into a string
representation, which blows my memory out of the water and drops my
transaction rate way way down while I spend most of my time working with a
StringBuffer.

I note that there is this web page:
http://wiki.postgresql.org/wiki/JDBC-BinaryTransfer

Which makes me think I might be saved. Has anyone used Binary Transfer for
Double[] (or other) array data?
Any pointers to some implementation would be great...
Right now I have my own implementation that extends java.sql.Array, and
contains the string and a typeName and num.

Regards,
-JD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-04-01 03:37:15 Re: postgres conferences missing videos?
Previous Message Marco Colombo 2011-04-01 02:00:35 Re: pg_restore