LOL - lemme get this straight...CHAR to improve performance, but using rpad to make it *actually work*?
Your DBA needs a kick in the mojos. ;-) My guess is that VARCHAR would make for better performance than CHAR + a call to RPAD() *for each row of every query*. Maybe I am just smoking crack... Larry On 8/3/06, jeb001 <[EMAIL PROTECTED]> wrote:
In order to be performant and light, my DBA prefers use CHAR type than VARCHAR columns.. So, I have to set that 'rpad' explicitly for each columns.. Maybe Abator could set that 'rpad' for eahch Char column.. I don't know how to set that in Java code, do you ? -- View this message in context: http://www.nabble.com/Abator---oracle-pb-with-CHAR-columns-tf2045970.html#a5634205 Sent from the iBATIS - User - Java forum at Nabble.com.
