I did a fairly extensive test on this a year or so ago. I found no discernable performance difference either way.
As with all performance claims - your milage may vary. It's best to try it out in your environment to verify. Jeff Butler On 7/26/07, Tom Henricksen <[EMAIL PROTECTED]> wrote:
A co-worker who uses the .Net version of iBatis mentioned that it is strongly suggested to add javaTypes and jdbcTypes in resultMaps. I presume this is the same for Java? This: <result property="provider.rowVersion" column="H_PRVDRID" jdbcType="int" javaType="java.lang.Integer" /> instead of this: <result property="provider.rowVersion" column="H_PRVDRID" /> They said that doing this in Java they noticed a faster initial response than without. I imagine the reflection used to determine the types is time consuming. Then after that they run the same. I presume the types are cached somehow? Also how long does it cache? Is that determined on available memory or some other setting? http://www.nabble.com/When-to-use-jdbcType-or-javaType-tf2048046.html#a5748022 According to this they may help performance and are useful in resultMaps, correct? Thanks, *Tom Henricksen* Consultant Advanced Technologies Group, Inc.
