db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4800) Allow bulk scan of LOB tables with holdable cursors
Date Thu, 16 Sep 2010 12:56:33 GMT
Allow bulk scan of LOB tables with holdable cursors

                 Key: DERBY-4800
                 URL: https://issues.apache.org/jira/browse/DERBY-4800
             Project: Derby
          Issue Type: Improvement
    Affects Versions:
            Reporter: Knut Anders Hatlen
            Priority: Minor

DERBY-1511 disabled bulk scans for tables with LOBs if the cursor was holdable. This was done
to work around a bug, but it had a very negative impact on queries that scanned tables that
contained relatively small LOBs. It would be good if we could find a safe way to re-enable
bulk scans for these queries.

The problem now is that the lob containers are closed on the transaction boundaries, so the
buffered values will be dead on arrival when we call next() after a commit(). If we could
find a way to make the containers survive across the transaction boundary, or make it possible
to reopen the container, it should be safe to re-enable the bulk scans.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message