Some tips on improve the Mybatis performance.
- Set fetchSize to a considerable amount.
- Only retrieve needed columns from DB and map them to the Java object.
- Try to reduce the nested selects in one user interaction, try to use more nested joins in the SQL level in one time DB call.
- Use cache integration to improve re-read speed. Such as Memcached or Ehcache
- SQL and DB self optimization, such as index for sort and order