You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Paulo Jesus <pa...@gmail.com> on 2007/09/03 19:53:58 UTC
Question on derby benchmarks.
I have developed some code on engine of Derby ver 10.2.2. Is part of
larger project GAPI from GORDA project, (support for replication
services), that uses embedded code. The project was not ported to ver
10.3 yet.
I putted these question on list Derby-users but, after short talk
here, i think maybe is best here.
I wonder what benchmarks have been in use by the Derby team. TPC-B?
And were can i find the source of those tests.
The specification I need is.
- TPC-W and TPC-C tests use SetMaxRows statement that derby does not
support. I'm looking a test ajusted to Derby.
- Support for various users to generate conflict in querys. This is
the main argument to be tested. Poleposition test is good to test
overhead caused by new code but not for this.
If there is some test adjusted please tell me. If i couldn't find any,
i will start to build one simple test.
Thanks
PJ
Re: Question on derby benchmarks.
Posted by Paulo Jesus <pa...@gmail.com>.
Thanks Daniel.
If the test is TPC-C like i believe there is, in the replication
project, interest in.
TPC-C test was discarded, maybe this test ("Order Entry") is good enough.
I will use it soon. For now i found a error whit a simple test, and
I'm getting trouble to correct it. If i can't, I will post here for
help.
I need to relate Exceptions on transactions to force the abort of them
and ContextManager.popContext(..) gerenrating
ArrayIndexOutOfBoundsException error.
PJ
2007/9/6, Daniel John Debrunner <dj...@apache.org>:
> Paulo Jesus wrote:
> > I have developed some code on engine of Derby ver 10.2.2. Is part of
> > larger project GAPI from GORDA project, (support for replication
> > services), that uses embedded code. The project was not ported to ver
> > 10.3 yet.
> >
> > I putted these question on list Derby-users but, after short talk
> > here, i think maybe is best here.
> >
> > I wonder what benchmarks have been in use by the Derby team. TPC-B?
> > And were can i find the source of those tests.
>
> Olav from Sun seems to have a TPC-B like benchmark using Derby but I
> don't believe the source is available.
>
> http://wiki.apache.org/apachecon-data/attachments/Us2005OnlineSessionSlides/attachments/ApacheCon05usDerbyPerformance.pdf
>
> The Derby codeline has an almost complete implementation of a TPC-C like
> benchmark called "Order Entry". It follows the TPC-C spec for the
> transaction implementation and data loading but is not claiming to be a
> compliant TPC-C. The idea is that is can be used as a base for
> performance testing, system testing etc. One could implement the logical
> function of the TPC-C transactions differently to evaluate performance
> of certain Derby features, e.g. by using identity columns for new order
> number instead of the method prescribed in the TPC-C spec.
>
> The code is under
>
> java/testing/org/apache/derbyTesting/system/oe
>
> It has the code to load a database and the business transactions
> implemented in one simple form. I just added a class that supports
> submitting transactions, which is partially implemented.
>
> Feel free to get involved and improve it.
> Dan.
>
Re: Question on derby benchmarks.
Posted by Dy...@Sun.COM.
John Sisson <jr...@gmail.com> writes:
> It appears that it should go through the IP Clearance process that you
> mentioned. AFAIK IBM had to go through the same process for the Derby
> network server tests, see the see the
> derby-2248-contribution-tests-ibm
> <http://incubator.apache.org/ip-clearance/derby-2248-contribution-tests-ibm.html>
> link on the IP clearance page.
>
> The Derby PMC would be responsible for filing an IP clearance form.
Thanks, John :)
(I ended up starting a new thread under the Subject "How
to donate code to Apache) since not many people appeared to be
following this old thread.)
--
dt
Re: Question on derby benchmarks.
Posted by John Sisson <jr...@gmail.com>.
It appears that it should go through the IP Clearance process that you
mentioned. AFAIK IBM had to go through the same process for the Derby
network server tests, see the see the derby-2248-contribution-tests-ibm
<http://incubator.apache.org/ip-clearance/derby-2248-contribution-tests-ibm.html>
link on the IP clearance page.
The Derby PMC would be responsible for filing an IP clearance form.
Regards,
John
Dyre.Tjeldvoll@Sun.COM wrote:
> Daniel John Debrunner <dj...@apache.org> writes:
>
>
>> Paulo Jesus wrote:
>>
>>> I have developed some code on engine of Derby ver 10.2.2. Is part of
>>> larger project GAPI from GORDA project, (support for replication
>>> services), that uses embedded code. The project was not ported to ver
>>> 10.3 yet.
>>> I putted these question on list Derby-users but, after short talk
>>> here, i think maybe is best here.
>>> I wonder what benchmarks have been in use by the Derby team. TPC-B?
>>> And were can i find the source of those tests.
>>>
>> Olav from Sun seems to have a TPC-B like benchmark using Derby but I
>> don't believe the source is available.
>>
>> http://wiki.apache.org/apachecon-data/attachments/Us2005OnlineSessionSlides/attachments/ApacheCon05usDerbyPerformance.pdf
>>
>
> I'm happy to announce that Sun has decided to donate the tests used by
> Olav to the ASF and Derby.
>
> We are, however, a bit unsure about how to proceed. Can we simply
> attach the files to a Jira issue and check the "Grant license to ASF for
> inclusion in ASF works (as per the Apache License §5)" checkbox, or do
> we need to to go through IP clearance
> (http://incubator.apache.org/ip-clearance/index.html), for this
> contribution?
>
> There are 3 tests (single record load, tpcb-like load and join load)
> consisting of 27 source files that make up about 7000 lines of code
> (wc -l).
>
> Any advice would be much appreciated.
>
> Thanks,
>
>
Re: Question on derby benchmarks.
Posted by Dy...@Sun.COM.
Daniel John Debrunner <dj...@apache.org> writes:
> Paulo Jesus wrote:
>> I have developed some code on engine of Derby ver 10.2.2. Is part of
>> larger project GAPI from GORDA project, (support for replication
>> services), that uses embedded code. The project was not ported to ver
>> 10.3 yet.
>> I putted these question on list Derby-users but, after short talk
>> here, i think maybe is best here.
>> I wonder what benchmarks have been in use by the Derby team. TPC-B?
>> And were can i find the source of those tests.
>
> Olav from Sun seems to have a TPC-B like benchmark using Derby but I
> don't believe the source is available.
>
> http://wiki.apache.org/apachecon-data/attachments/Us2005OnlineSessionSlides/attachments/ApacheCon05usDerbyPerformance.pdf
I'm happy to announce that Sun has decided to donate the tests used by
Olav to the ASF and Derby.
We are, however, a bit unsure about how to proceed. Can we simply
attach the files to a Jira issue and check the "Grant license to ASF for
inclusion in ASF works (as per the Apache License §5)" checkbox, or do
we need to to go through IP clearance
(http://incubator.apache.org/ip-clearance/index.html), for this
contribution?
There are 3 tests (single record load, tpcb-like load and join load)
consisting of 27 source files that make up about 7000 lines of code
(wc -l).
Any advice would be much appreciated.
Thanks,
--
dt
Re: Question on derby benchmarks.
Posted by Daniel John Debrunner <dj...@apache.org>.
Paulo Jesus wrote:
> I have developed some code on engine of Derby ver 10.2.2. Is part of
> larger project GAPI from GORDA project, (support for replication
> services), that uses embedded code. The project was not ported to ver
> 10.3 yet.
>
> I putted these question on list Derby-users but, after short talk
> here, i think maybe is best here.
>
> I wonder what benchmarks have been in use by the Derby team. TPC-B?
> And were can i find the source of those tests.
Olav from Sun seems to have a TPC-B like benchmark using Derby but I
don't believe the source is available.
http://wiki.apache.org/apachecon-data/attachments/Us2005OnlineSessionSlides/attachments/ApacheCon05usDerbyPerformance.pdf
The Derby codeline has an almost complete implementation of a TPC-C like
benchmark called "Order Entry". It follows the TPC-C spec for the
transaction implementation and data loading but is not claiming to be a
compliant TPC-C. The idea is that is can be used as a base for
performance testing, system testing etc. One could implement the logical
function of the TPC-C transactions differently to evaluate performance
of certain Derby features, e.g. by using identity columns for new order
number instead of the method prescribed in the TPC-C spec.
The code is under
java/testing/org/apache/derbyTesting/system/oe
It has the code to load a database and the business transactions
implemented in one simple form. I just added a class that supports
submitting transactions, which is partially implemented.
Feel free to get involved and improve it.
Dan.