Dashboard > iBATIS DataMapper > Home > Frequently Asked Questions > How do I improve SQL Map performance
How do I improve SQL Map performance
Added by Clinton Begin, last edited by Ted Husted on Sep 15, 2005  (view change)

If you're using SQL Maps 2.0, then here's what you want to do (in
order of importance):

1. Ensure you've specified a parameterMap or parameterClass attribute
on your statement.

2. Use an explicitly defined <resultMap> and DON'T allow remapping of
results (new 2.0.9 feature)

3. Use a Java``Bean (not a Map or XML etc.)

4. Make sure all of your properties are "simple properties" (no
dot.notation, array[] access or mixed bean/map properties).

5. Try enabling bytecode enhancement in your <settings> element.

Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators