[Db-derby Wiki] Update of "Derby1961ResourceUsage" by KnutAndersHatlen

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by KnutAndersHatlen:
http://wiki.apache.org/db-derby/Derby1961ResourceUsage

New page:
== Resource Usage in Derby ==

This page contains results found when investigating Derby's resource
usage ([http://issues.apache.org/jira/browse/DERBY-1961 DERBY-1961]).
If you have numbers you want to share, please add them
to the Results section at the end.

=== Load ===

The testing uses the load clients in
[http://issues.apache.org/jira/browse/DERBY-1961 DERBY-1961]. They are
able to perform three kinds of operations:

  1. Single-record select operations. Each transaction reads one row from a table of 100000 rows (each row is around 100 bytes).
  1. Single-record update operations. Each transaction updates one row in a table of 100000 rows (the same table as the select operations).
  1. Join operations. Joins one table of 10000 rows with a table of 1000 rows. The result contains 1000 rows.

All three load types access the rows by primary key.

The tests are run as client/server tests so that the resource usage of
the network server can be compared to the amount of resources used by
the other parts of Derby. To make sure that the page cache can hold
the entire database, increase the page cache size by starting the
network server with `-Dderby.storage.pageCacheSize=12500`.

=== Modules ===

When looking at where Derby consumes resources, it helps to divide the
code into modules or layers. Since the Derby code already is
structured in packages, the modules could be defined in terms of the
code packages:

|| '''Module'''   || '''Derby package''' ||
|| Network server || `org.apache.derby.drda` and `org.apache.derby.impl.drda` ||
|| JDBC           || `org.apache.derby.jdbc` and `org.apache.derby.impl.jdbc` ||
|| Execution      || `org.apache.derby.impl.sql` ||
|| Access         || `org.apache.derby.impl.store.access` ||
|| Lock manager   || `org.apache.derby.impl.services.locks` ||
|| Buffer manager || `org.apache.derby.impl.services.cache` ||
|| Logging        || `org.apache.derby.impl.store.raw.log` ||
|| Data store     || `org.apache.derby.impl.store.raw.data` ||
|| Transaction control || `org.apache.derby.impl.store.raw.xact` ||

=== Results ===

Soon to come...