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.

Reply via email to