You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/11/13 11:01:55 UTC

[Db-derby Wiki] Update of "Derby1961ResourceUsage2" by KristianWaagan

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 KristianWaagan:
http://wiki.apache.org/db-derby/Derby1961ResourceUsage2

------------------------------------------------------------------------------
  The CPU times include both system and user CPU.
  The runs were done on a Solaris 10 machine with x86 hardware. Wall clock time
  were obtained using ''gethrtime'' and the CPU times using ''getrusage''. [[BR]]
+ The network server was run with Java SE 6 (build 104, 64 bit Server VM). !TestClient was configured with 30 seconds of warmup and 120 seconds runtime ("steady state").
- The test client was run with Java SE 6 (build 103), 35 seconds of warmup and 120 seconds runtime ("steady state").
- 
- '''Numbers are under validation. They might change!'''
  
  || ||<-2> '''Single-record select (10 clients)''' ||<-2> '''Single-record update (20 clients)''' ||<-2> '''Join (4 clients)''' ||
  || '''Module''' || '''System & user CPU''' || '''Wall clock time''' || '''System & user CPU''' || '''Wall clock time''' || '''System & user CPU''' || '''Wall clock time''' ||
+ || Network server ||<style="text-align: right;"> 14.5% ||<style="text-align: right;"> 47.0% ||<style="text-align: right;"> 10.8% ||<style="text-align: right;">  6.0% ||<style="text-align: right;">  1.3% ||<style="text-align: right;">  1.0% ||
+ || JDBC ||<style="text-align: right;">  4.1% ||<style="text-align: right;">  1.4% ||<style="text-align: right;">  1.0% ||<style="text-align: right;">  0.0% ||<style="text-align: right;">  2.4% ||<style="text-align: right;">  1.0% ||
+ || Execution ||<style="text-align: right;">  7.9% ||<style="text-align: right;">  2.6% ||<style="text-align: right;">  8.1% ||<style="text-align: right;">  0.4% ||<style="text-align: right;">  4.7% ||<style="text-align: right;">  2.7% ||
+ || Access ||<style="text-align: right;"> 18.1% ||<style="text-align: right;">  7.0% ||<style="text-align: right;"> 13.2% ||<style="text-align: right;">  0.8% ||<style="text-align: right;"> 32.5% ||<style="text-align: right;"> 24.6% ||
+ || Lock manager ||<style="text-align: right;"> 19.7% ||<style="text-align: right;"> 30.9% ||<style="text-align: right;"> 18.8% ||<style="text-align: right;"> 10.0% ||<style="text-align: right;"> 13.5% ||<style="text-align: right;"> 40.6% ||
+ || Buffer manager ||<style="text-align: right;">  6.8% ||<style="text-align: right;">  2.3% ||<style="text-align: right;">  5.5% ||<style="text-align: right;">  0.3% ||<style="text-align: right;">  1.3% ||<style="text-align: right;">  0.7% ||
+ || Logging ||<style="text-align: right;">  0.0% ||<style="text-align: right;">  0.0% ||<style="text-align: right;"> 11.0% ||<style="text-align: right;"> 81.1% ||<style="text-align: right;">  0.0% ||<style="text-align: right;">  0.0% ||
+ || Data store ||<style="text-align: right;"> 23.6% ||<style="text-align: right;">  7.2% ||<style="text-align: right;"> 24.4% ||<style="text-align: right;"> 1.1% ||<style="text-align: right;"> 33.4% ||<style="text-align: right;"> 22.2% ||
+ || Transaction control ||<style="text-align: right;">  5.3% ||<style="text-align: right;">  1.8% ||<style="text-align: right;">  7.3% ||<style="text-align: right;">  0.3% ||<style="text-align: right;"> 10.8% ||<style="text-align: right;">  7.2% ||
- || Network server ||<style="text-align: right;"> 13.4% ||<style="text-align: right;"> 72.2% ||<style="text-align: right;">  9.0% ||<style="text-align: right;"> 24.8% ||<style="text-align: right;">  1.4% ||<style="text-align: right;">  1.5% ||
- || JDBC ||<style="text-align: right;">  4.1% ||<style="text-align: right;">  1.2% ||<style="text-align: right;">  0.9% ||<style="text-align: right;">  0.2% ||<style="text-align: right;">  2.2% ||<style="text-align: right;">  1.1% ||
- || Execution ||<style="text-align: right;">  7.8% ||<style="text-align: right;">  2.1% ||<style="text-align: right;">  8.4% ||<style="text-align: right;">  1.4% ||<style="text-align: right;">  5.0% ||<style="text-align: right;">  3.1% ||
- || Access ||<style="text-align: right;"> 18.2% ||<style="text-align: right;">  4.6% ||<style="text-align: right;"> 13.2% ||<style="text-align: right;">  2.4% ||<style="text-align: right;"> 30.0% ||<style="text-align: right;"> 17.7% ||
- || Lock manager ||<style="text-align: right;"> 20.8% ||<style="text-align: right;"> 11.7% ||<style="text-align: right;"> 23.1% ||<style="text-align: right;"> 15.0% ||<style="text-align: right;"> 15.8% ||<style="text-align: right;"> 40.9% ||
- || Buffer manager ||<style="text-align: right;">  8.0% ||<style="text-align: right;">  1.9% ||<style="text-align: right;">  6.6% ||<style="text-align: right;">  1.0% ||<style="text-align: right;">  1.2% ||<style="text-align: right;">  0.8% ||
- || Logging ||<style="text-align: right;">  0.0% ||<style="text-align: right;">  0.0% ||<style="text-align: right;"> 10.5% ||<style="text-align: right;"> 51.5% ||<style="text-align: right;">  0.0% ||<style="text-align: right;">  0.0% ||
- || Data store ||<style="text-align: right;"> 22.5% ||<style="text-align: right;">  5.1% ||<style="text-align: right;"> 21.3% ||<style="text-align: right;">  2.7% ||<style="text-align: right;"> 33.2% ||<style="text-align: right;"> 26.1% ||
- || Transaction control ||<style="text-align: right;">  5.1% ||<style="text-align: right;">  1.3% ||<style="text-align: right;">  7.0% ||<style="text-align: right;">  1.0% ||<style="text-align: right;"> 11.2% ||<style="text-align: right;">  8.8% ||
- 
  
  ==== Object allocations ====