Performance tests

This page summarizes results from running some simple performance tests comparing the performance of the 10.8.1.2 release and the 10.8.2.2 release candidate.

The tests ran on dual-CPU AMD Opteron machines running Solaris 10 x86 and Java SE 7.

All tests came from the java/testing/org/apache/derbyTesting/perf/clients/ directory in the Derby repository (using the load clients sr_select, sr_update, index_join and bank_tx).

Embedded

Single-record SELECT operations using primary key

Single-record UPDATE operations using primary key

Joining two tables (1000x10000 rows) using index

Bank transactions

Client/server

Single-record SELECT operations using primary key

Single-record UPDATE operations using primary key

Joining two tables (1000x10000 rows) using index

Bank transactions