Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <347023879.1246889654930.JavaMail.jira@brutus>
Date: Mon, 6 Jul 2009 07:14:14 -0700 (PDT)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-3312) Local Network Server Performance
 degradation with 10.2 or later
In-Reply-To: <10468865.1199928633988.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3312:
----------------------------------

      Issue & fix info: [High Value Fix, Repro attached]  (was: [High Value Fix])
    Bug behavior facts: [Performance, Regression, Seen in production]  (was: [Regression, Performance])

Triaged for 10.5.2.  I verified that this is still an issue with 10.5. The program LobPerf ran 
126375ms with 10.1.3.1
696594ms with 10.5.1.1

so more than 5 times slower.    When I ran it seemed that later iterations were running slower, so I thought maybe the lobs were not getting garbage collected properly since they were not being freed, so perhaps thrashing was causing the slow down.  I added a c.free after each row and found it to be almost three times as slow as the 10.5 run without the free: 1973109ms. 

I'll leave this as urgent since it seems to be a serious regression, although I don't know if anyone has any good ideas how we might fix this, especially in a maintenance release.


> Local Network Server Performance degradation with 10.2 or later
> ---------------------------------------------------------------
>
>                 Key: DERBY-3312
>                 URL: https://issues.apache.org/jira/browse/DERBY-3312
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server
>    Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1
>         Environment: Intel x86 based server SuSE Linux Enterprise Server 10
> Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
> Derby 10.3.2.1
>            Reporter: Timothy Graf
>         Attachments: LobPerf.java
>
>
> We have a Java based XML-RPC client/server product that incorporates an embedded Derby database and network server.  Our client uses the derby JDBC ndriver and network client to connect to the Derby Network Server.
> We recently moved from Cloudscape, which I believe used the 10.1.3.1 Derby code, because of other issues which seem to be resolved by moving to the latest Derby release.  We have a very simple database with a simple table.  This table does include BLOBs, however its size has not been an issue and we limit our records to 500.
> Since moving to the latest release of Derby, version 10.3.2.1, we noticed that our clients running on the same machine as our server take much longer to retrieve a list of records from the database.  Our clients running on a remote machine do not seem to have any performance issues when retrieving the same list of records.
> We start our Network Server in Java through the API so I don't think the Security Manager is the issue.  I read that performance could be affected by the Security Manager, but according to the Derby documentation, 
> "The Network Server will not attempt to install a security manager if you start the server from your application using the programmatic API ..."
> I tried going back several releases of Derby and the performance issue seems to go away when I run with version 10.1.3.1 of Derby.  However we see the same issue that we saw with Cloudscape in that we can not turn off connection logging.  We also had stability problems with the Network Server with Cloudscape.
> We would really prefer to use the latest Derby release however the performance issues are a sever limitation.  I thought that maybe this was a simple Network Server configuration issue however after researching this issue I have not found anything from a configuration standpoint that may help.

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