[ http://issues.apache.org/jira/browse/DERBY-1276?page=all ] Andreas Korneliussen closed DERBY-1276: ---------------------------------------
Thanks for committing. Closing this report since it is a minor issue, which is resolved on 10.2 trunk. If anyone want to port it to the 10.1.3 branch (and have a hard time porting this issue), please reopen the issue, and let me know if you want me to consult. > Calling ResultSet.isLast() on a scrollable insensitive resultset, causes the > entire ResultSet to be populated > ------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1276 > URL: http://issues.apache.org/jira/browse/DERBY-1276 > Project: Derby > Type: Improvement > Components: SQL > Versions: 10.2.0.0, 10.1.3.0 > Reporter: Andreas Korneliussen > Assignee: Andreas Korneliussen > Priority: Minor > Fix For: 10.2.0.0 > Attachments: DERBY-1276.diff, DERBY-1276.stat, derbyall_report.txt > > The following is not a bug, however some applications do not always need to > scroll to the last row, however they do want to check isLast(). Therefore it > is unfortunate that isLast() is expensive. The general logic in > ScrollInsensitiveResultSet is to populate rows by demand. > The current logic in ScrollInsensitiveResultSet to return true or false on > isLast(), is to move to the last row. If the last row is not the same row > number as the current, then isLast() returns false. When moving to the last > row, all rows will be populated into the BackingStoreHashtable of the > ScrollInsensitiveResultSet. > This logic may be rewritten to only move to the next row. If the next row > exists, isLast() may return false. > (note the logic is also optimized to use beforeFirst and afterLast flags) -- 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
