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
