db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <j...@apache.org>
Subject [jira] Commented: (DERBY-2634) CLOB performance partially very poor on linux system
Date Thu, 10 May 2007 13:48:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12494749
] 

Øystein Grøvlen commented on DERBY-2634:
----------------------------------------

Which version of Derby have you been using?  

For the next version of Derby (10.3) we are changing the way LOBs are sent between client
and server.  The main purpose is to reduce the memory requirements when dealing with large
LOBs, but I think the performance should improve for some operations.  The new code has been
checked into the development branch, but it has not yet been enabled.  It should be available
by the end of this month.

Thanks for the test case.  I will try to run it and see if 10.3 will give any improvements.



> CLOB performance partially very poor on linux system
> ----------------------------------------------------
>
>                 Key: DERBY-2634
>                 URL: https://issues.apache.org/jira/browse/DERBY-2634
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Client, Network Server, Performance
>    Affects Versions: 10.2.2.0, 10.3.0.0
>         Environment: gnu linux, network client and network server on the same machine
>            Reporter: Frank-Ralph Reiser
>         Attachments: derbytest-linux-laptop-1.66GHz.txt, testcase.zip
>
>
> Doing some performance tests with several differente database implementations, we noticed
very poor query performance of apache derby under certain conditions.
> If the select statement selects a CLOB column and if it contains a subselect, traversing
the ResultSet takes very long with nearly no cpu load.

-- 
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