title: Oracle JDBC performance of ResultSet
body: <p>I was using so far something like this for querying my database that was working perfectly fine :</p>
  
  <pre><code>PreparedStatement prepStmt = dbCon.prepareStatement(mySql);
  ResultSet rs = prepStmt.executeQuery();
  </code></pre>
  
  <p>But then I needed to use the <code>rs.first();</code> in order to be able to iterate over my <code>rs</code> multiple times. So I use now </p>
  
  <pre><code>PreparedStatement prepStmt = dbCon.prepareStatement(mySql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);    
  </code></pre>
  
  <p>My question is related to the performance of the two. What do I lose if I use the second option? Will using the second option have any negative effect in the code that I have written so far?</p>
  
  <p>PS: Note that my application is a multi-user, database-intensive web application (on a Weblogic 10.3.4) that uses a back end Oracle 11g database. </p>
  
  <p>Thanks all for your attention.  </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>My maximum reslutset size will be less than 1000 rows and 15-20 columns</p>