Opened 12 years ago

Last modified 9 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
Cc:

Description

[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.

Change History (1)

comment:1 Changed 9 years ago by dlove

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