title: How to set fetchSize for iBatis select statement
body: <p>I'm using iBatis as ORM framework in Java.
  I have a select statement </p>
  
  <pre><code>&lt;select id="getList" resultMap="correctMap"&gt;
      SELECT *
      FROM SOME_TABLE
  &lt;/select&gt;
  </code></pre>
  
  <p>And I'm using queryForList method:</p>
  
  <pre><code>List&lt;MappedObject&gt; list = getSqlMapClientTemplate().queryForList("getList");
  </code></pre>
  
  <p>But it retrieves a big amount of data and performance of this query is pretty slow.</p>
  
  <p>My assumption about this issues that iBatis has default fetch size (e.g. like in JDBS is 10) so that is why it so slow. So I want to set bigger fetch size (1000 for example). How I can do so?</p>
  
  <p>Or am I looking in a wrong way?</p>
  
  <p>NOTE: I need all data so set max results in <code>queryForList</code> method is not a appropriate solution for me.</p>
  
  <pre><code>List queryForList(String id,
                    Object parameterObject,
                    int skip,
                    int max) 
  </code></pre>