I use iBatis 2.3.4
I have the following query:
<select id="getUserList" resultMap="userListResult">
SELECT
id,
name,
login,
email
FROM
users
</select>
And when I need to provide paging I use:
sqlMap.queryForList("base.getUserList", startPosition, numItems);
Then iBatis generates query without limit, and skips extra data during fetching. I belive that work with limits is more faster.
How can we push iBatis to use LIMIT generally? Is It possible? May be we can describe some dialect?