Back to dtable optimization. I'm now only retrieving the numerical value of cells for columns with sort order NUM. The new object counts are:

char[] 3.5k
String 3k
byte[] 2k
StringBuffer 1k

I don't think these will get much lower - the percentages of each allocated within retrieveDTable itself are:

char[] 17%
String 20%
byte[] 72%
StringBuffer 1%

so there's only byte[] which really stands out against the background radiation. All of that 72% allocation occur within the psql driver, so unless we trim the sql call down even further there's nothing to do. Diminishing returns on that. I'll look at the cpu time used instead before moving on.

T
- posted by Tim Bruce @ 12:10 PM