db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "Derby1961ResourceUsage" by KnutAndersHatlen
Date Tue, 17 Oct 2006 14:42:48 GMT
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

------------------------------------------------------------------------------
  || Data store     ||<style="text-align: right;"> 1099 B/tx ||<style="text-align:
right;"> 30 objs/tx ||<style="text-align: right;"> 1327 B/tx ||<style="text-align:
right;"> 36 objs/tx ||<style="text-align: right;"> 92658 B/tx ||<style="text-align:
right;"> 22960 objs/tx ||
  || Transaction control ||<style="text-align: right;"> 80 B/tx ||<style="text-align:
right;"> 3 objs/tx ||<style="text-align: right;">  136 B/tx ||<style="text-align:
right;"> 6 objs/tx ||<style="text-align: right;"> 80 B/tx ||<style="text-align:
right;"> 3 objs/tx ||
  
+ ==== System calls per module ====
+ 
+ Results found by logging all system calls on the database server with DTrace.
+ 
+ || '''Module'''        || '''Single-record select (10 clients)''' || '''Single-record update
(20 clients)''' || '''Join (4 clients)''' ||
+ || Network server      || 4.0 scl/tx                              || 4.0 scl/tx        
                     ||  4.0 scl/tx            ||
+ || JDBC                ||                                         ||                   
                     ||                        ||
+ || Execution           ||                                         ||                   
                     ||                        ||
+ || Access              ||                                         ||                   
                     ||                        ||
+ || Lock manager        || 1.9 scl/tx                              || 0.6 scl/tx        
                     || 18.4 scl/tx            ||
+ || Buffer manager      ||                                         ||                   
                     ||  0.2 scl/tx            ||
+ || Logging             ||                                         || 2.0 scl/tx        
                     ||                        ||
+ || Data store          ||                                         || 0.4 scl/tx        
                     ||  0.2 scl/tx            ||
+ || Transaction control ||                                         ||                   
                     ||                        ||
+ || Unknown             ||                                         ||                   
                     ||  0.5 scl/tx            ||
  
  More to come...
  

Mime
View raw message