[#DERBY-822] Client driver: Pre-fetch data on executeQuery()

Derby

Client driver: Pre-fetch data on executeQuery()

Created: 18/Jan/06 07:52 PM Updated: 30/Jun/09 04:12 PM

Return to search

Component/s:

Network Server

Affects Version/s:

10.2.1.6

Fix Version/s:

10.2.1.6

Time Tracking:

Issue & Sub-Tasks

Issue Only

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
DERBY-822-v1.diff	2006-02-17 10:58 PM	Knut Anders Hatlen	813 kB
DERBY-822-v1.stat	2006-02-17 10:58 PM	Knut Anders Hatlen	1 kB
DERBY-822-v2.diff	2006-04-05 09:56 PM	Knut Anders Hatlen	12 kB
DERBY-822-v2.stat	2006-04-05 09:56 PM	Knut Anders Hatlen	0.5 kB
DERBY-822-v3.diff	2006-04-18 04:51 AM	Knut Anders Hatlen	10 kB
DERBY-822-v3.stat	2006-04-18 04:51 AM	Knut Anders Hatlen	0.5 kB

Issue & fix info:	Release Note Needed
Bug behavior facts:	Performance
Resolution Date:	18/Apr/06 01:55 PM

Sub-Tasks:

All

Open

No sub-tasks match this view.

Description

« Hide

Currently, the client driver does not pre-fetch data when
executeQuery() is called, but it does on the first call to
ResultSet.next(). Pre-fetching data on executeQuery() would reduce
network traffic and improve performance.

The DRDA protocol supports this. From the description of OPNQRY (open
query):

  The qryrowset parameter specifies whether a rowset of rows is to be
  returned with the command. This is only honored for non-dynamic
  scrollable cursors (QRYATTSNS not equal to QRYSNSDYN) and for
  non-scrollable cursors conforming to the limited block query
  protocol. The target server fetches no more than the requested
  number of rows. It may fetch fewer rows if it is restricted by extra
  query block limits, or if a fetch operation results in a negative
  SQLSTATE or an SQLSTATE of 02000.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Knut Anders Hatlen made changes - 03/Feb/06 07:45 AM

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Knut Anders Hatlen made changes - 17/Feb/06 10:58 PM

Attachment		DERBY-822-v1.stat [ 12323110 ]
Attachment		DERBY-822-v1.diff [ 12323109 ]

Knut Anders Hatlen made changes - 05/Apr/06 09:57 PM

Attachment		DERBY-822-v2.stat [ 12324986 ]
Attachment		DERBY-822-v2.diff [ 12324985 ]

Knut Anders Hatlen made changes - 06/Apr/06 12:40 AM

Derby Info		[Patch Available]
Component/s	Network Client [ 11690 ]

Knut Anders Hatlen made changes - 18/Apr/06 04:51 AM

Attachment		DERBY-822-v3.diff [ 12325456 ]
Attachment		DERBY-822-v3.stat [ 12325457 ]

Knut Anders Hatlen made changes - 18/Apr/06 01:55 PM

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Kathey Marsden made changes - 29/Jun/06 10:53 PM

Derby Info

[Patch Available]

[Existing Application Impact, Release Note Needed]

Dag H. Wanvik made changes - 29/Jun/09 01:47 PM

Component/s

Performance [ 11709 ]

Dag H. Wanvik made changes - 29/Jun/09 02:39 PM

Derby Categories

[Performance]

Dag H. Wanvik made changes - 30/Jun/09 04:12 PM

Issue & fix info

[Release Note Needed, Existing Application Impact]

[Release Note Needed]