Opened 14 years ago
Last modified 10 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 10 years ago by dlove
- Component changed from sge to arco
- Severity set to minor
Note: See
TracTickets for help on using
tickets.