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
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 |