db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3934) Improve performance of reading modified Clobs
Date Wed, 05 Nov 2008 10:41:44 GMT
Improve performance of reading modified Clobs
---------------------------------------------

                 Key: DERBY-3934
                 URL: https://issues.apache.org/jira/browse/DERBY-3934
             Project: Derby
          Issue Type: Improvement
          Components: JDBC
    Affects Versions: 10.5.0.0
            Reporter: Kristian Waagan
            Assignee: Kristian Waagan


The performance of reading modified Clobs is poor, which is demonstrated by running a test
program selecting a 10 MB Clob and then getting the contents using getSubString:
 - unmodified Clob (StoreStreamClob) : ~1 300 ms
 - modified Clob (TemporaryClob): ~156 000 ms

In this case, the Clob was modified by changing the first character.

A number of subtasks will be created to handle the various issues, which will be related to
both performance and code cleanup.
For a brief overview, see http://www.nabble.com/Suggestion-for-improving-ClobUpdatableReader-and-related-code-to20308303.html

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


Mime
View raw message