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)
Labels: 
(None)


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