title: Is there a way to intelligently set fetch size on JdbcTemplate?
body: <p>I have query that return reports by a date range.  If the date range is large, 50k rows may be returned.  If the date range is very small, 10 records could be returned.  I've found that setting the fetch size to 1000, when 50k rows are returned greatly speeds up the execution time.  But setting it to 1000 when 10 rows are returned slows it down and uses up excessive memory.  This is just one example, I have many queries that return few or many rows based on various conditions (type of job running, etc).</p>
  
  <p>Ideally, it would be nice if this could be auto-set after the query is executed (but before the rows are returned).</p>
  
  <p>Is there a better way to do this?</p>
  
  <p>I'm using org.springframework.jdbc.core.support.JdbcDaoSupport.SimpleJdbcDaoSupport
  getJdbcTemplate().setFetchSize(1000);</p>