title: Java JDBC ignores setFetchSize?
body: <p>I'm using the following code</p>
  
  <pre><code> st = connection.createStatement(
              ResultSet.CONCUR_READ_ONLY,
              ResultSet.FETCH_FORWARD,
              ResultSet.TYPE_FORWARD_ONLY
               );
   st.setFetchSize(1000);
   System.out.println("start query ");
   rs = st.executeQuery(queryString);
   System.out.println("done query");
  </code></pre>
  
  <p>The query return a lot of (800k) rows and it take a large time (~2m) between printing "start query" and "done query". When I manually put an "limit 10000" in my query there's no time between "start" and "done". Processing the results takes time so I guess it's overall faster if it just fetches 1k rows from the database, processes those and when it's running out of rows it can get new ones in the background.</p>
  
  <p>The ResultsSet.CONCUR_READ_ONLY etc where my last guess; am I missing something?</p>
  
  <p>(it's a postgresql 8.3 server)</p>