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