[ http://issues.apache.org/jira/browse/DERBY-822?page=all ]
Knut Anders Hatlen updated DERBY-822:
-------------------------------------
Attachment: DERBY-822-v3.diff
DERBY-822-v3.stat
Uploading new patch (DERBY-822-v3.diff) addressing Bryan's comments. Changes
from the previous patch:
- renamed clean-up method for Beetle 4758 from cleanUpAndCloseStatement to
cleanUpAndCloseResultSet
- assigned default values to QRYRTNDTA, QRYSCRREL and QRYROWNBR on OPNQRY, so
that writeQRYDTA() and writeFDODTA() can be used without changes before CNTQRY
has been called
Derbyall ran cleanly on Sun JVM 1.5, Solaris 10 x86.
> Client driver: Pre-fetch data on executeQuery()
> -----------------------------------------------
>
> Key: DERBY-822
> URL: http://issues.apache.org/jira/browse/DERBY-822
> Project: Derby
> Type: Improvement
> Components: Network Server, Performance
> Versions: 10.2.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Fix For: 10.2.0.0
> Attachments: DERBY-822-v1.diff, DERBY-822-v1.stat, DERBY-822-v2.diff,
> DERBY-822-v2.stat, DERBY-822-v3.diff, DERBY-822-v3.stat
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
