How can i improve SQL Map performance?
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 JavaBean (not a Map or XML etc.)
| Wiki Markup |
|---|
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.