IZ2340: Reporting should use the setFetchSize() on ResultSet

[jana]

[Imported from gridengine issuezilla ​http://gridengine.sunsource.net/issues/show_bug.cgi?id=2340]

        Issue #:      2340             Platform:     Sun           Reporter: jana (jana)
       Component:     gridengine          OS:        All
     Subcomponent:    arco             Version:      6.1              CC:    None defined
        Status:       NEW              Priority:     P3
      Resolution:                     Issue type:    ENHANCEMENT
                                   Target milestone: ---
      Assigned to:    jana (jana)
      QA Contact:     joga
          URL:
       * Summary:     Reporting should use the setFetchSize() on ResultSet
   Status whiteboard:
      Attachments:

     Issue 2340 blocks:
   Votes for issue 2340:


   Opened: Tue Jul 31 02:24:00 -0700 2007 
------------------------


The setFetchSize() gives the JDBC driver a hint as to the number of rows that
should be fetched from the database when more rows are needed for this ResultSet
object.

For example on Oracle this number is by default set to 10. By increasing the
value, the number of database calls can be reduced which in turn improves
performance.

The defaultRowPrefetch can also be passed in as a property when establishing a
connection.

   ------- Additional comments from joga Wed Sep 10 08:28:50 -0700 2008 -------
This is not a bug, but a RFE.