Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <647255714.1213374645056.JavaMail.jira@brutus>
Date: Fri, 13 Jun 2008 09:30:45 -0700 (PDT)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-3619) Implement more load types for
 org.apache.derbyTesting.perf.clients.Runner
In-Reply-To: <652627309.1208265785148.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-3619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen updated DERBY-3619:
--------------------------------------

    Attachment: create-accounts.diff

Here's the first increment on a test that can replace the TPC-B like test. This patch (create-accounts.diff) only adds code that creates and populates tables that can be used in the test. Will write test clients that perform operations on the tables later. I've tried to make the schema and the contents of the tables follow the TPC-B specification, but it would be great if someone else could take a look and verify that it is implemented correctly.

The code is located in the class org.apache.derbyTesting.perf.clients.BankAccountFiller, which I committed to the repository with revision 667586.

> Implement more load types for org.apache.derbyTesting.perf.clients.Runner
> -------------------------------------------------------------------------
>
>                 Key: DERBY-3619
>                 URL: https://issues.apache.org/jira/browse/DERBY-3619
>             Project: Derby
>          Issue Type: Test
>          Components: Performance
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: create-accounts.diff, lob.diff, no-pk.diff
>
>
> I'm planning to add some more load types to org.apache.derbyTesting.perf.clients.Runner so that we can run tests whose load is roughly equivalent to the tests run in Olav's nightly performance regression tests - http://home.online.no/~olmsan/derby/perf/. Having such tests available would make it easier to investigate performance regressions reported by those test runs. Currently, we have clients under o.a.dt.perf.clients that generate load that is similar to the single-record select and single-record update operations with primary key and the primary key join operations (in fact, the nightly regression tests have used the tests in derbyTesting.jar for these types of load for about a month now).
> For the following types of load, we don't have test clients in derbyTesting.jar:
>   1) tests for insert performance
>   2) tests for delete performance
>   3) single-record select + single-record update on secondary index
>   4) single-record select + single-record update on non-indexed column
>   5) TPC-B like transactions (should probably be called something else, but I think it's useful to have a test that uses the same schema and queries as described in the TPC-B spec)
> (3) and (4) are just variants over the existing single-record tests.

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