Opened 14 years ago

Last modified 11 years ago

#447 new enhancement

IZ2340: Reporting should use the setFetchSize() on ResultSet

Reported by: jana Owned by:
Priority: normal Milestone:
Component: arco Version: 6.1
Severity: minor Keywords: Sun arco


[Imported from gridengine issuezilla]

        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
       * Summary:     Reporting should use the setFetchSize() on ResultSet
   Status whiteboard:

     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

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

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

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

Change History (1)

comment:1 Changed 11 years ago by dlove

  • Component changed from sge to arco
  • Severity set to minor
Note: See TracTickets for help on using tickets.