Performance tests

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

The tests ran on dual-CPU AMD Opteron machines running Solaris 10 x86 and Java SE 7u4. The disk write cache was disabled, and the databases were configured with their log device on a separate disk (via the logDevice connection attribute).

The Java VM was started with these flags:

-d64 -XX:+AggressiveHeap -Dderby.storage.pageCacheSize=50000

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