ldas-dev Database cit_test Insertion Rates
Test Period March 07 2001 11:49:22
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-5_10
Memory: 256M real, 60M free, 168M swap in use, 1018M swap free
LDAS software ldas-0.0.16, IBM DB2 7.1 
Results are displayed in the order inserted.
Table #rows per block insert CPU time (secs) Wall Time (secs) Rate (#rows/sec)
process 1 0.030 0.088 11.378
process 10 0.080 0.072 139.047
process 100 0.370 0.454 220.336
process 1000 3.370 4.211 237.473
process_params 1 0.040 0.050 20.008
process_params 10 0.060 0.054 183.955
process_params 100 0.270 0.394 254.081
process_params 1000 2.460 2.953 338.639
frameset_chanlist 1 0.020 0.033 30.441
frameset_chanlist 10 0.040 0.046 219.404
frameset_chanlist 100 0.150 0.217 460.073
frameset_chanlist 1000 1.170 1.859 537.924
frameset_writer 1 0.020 0.031 32.531
frameset_writer 10 0.070 0.067 150.173
frameset_writer 100 0.300 0.417 240.010
frameset_writer 1000 2.940 3.788 263.992
segment_definer 1 0.020 0.030 33.416
segment_definer 10 0.050 0.056 177.377
segment_definer 100 0.260 0.298 335.381
segment_definer 1000 2.290 3.122 320.307
filter 1 0.020 0.033 30.568
filter 10 0.040 0.052 191.040
filter 100 0.180 0.233 429.408
filter 1000 1.610 2.142 466.853
frameset 1 0.030 0.062 16.084
frameset 10 0.050 0.063 157.706
frameset 100 0.220 0.355 281.947
frameset 1000 2.020 2.969 336.814
segment 1 0.030 0.028 35.101
segment 10 0.030 0.053 188.331
segment 100 0.130 0.157 637.751
segment 1000 1.040 1.863 536.769
filter_params 1 0.020 0.057 17.475
filter_params 10 0.080 0.086 116.709
filter_params 100 0.250 0.360 277.574
filter_params 1000 2.450 3.293 303.674
gds_trigger 1 0.040 0.087 11.505
gds_trigger 10 0.070 0.079 126.690
gds_trigger 100 0.350 0.535 187.005
gds_trigger 1000 3.330 5.568 179.598
sngl_inspiral 1 0.040 0.078 12.790
sngl_inspiral 10 0.060 0.071 141.629
sngl_inspiral 100 0.240 0.330 303.272
sngl_inspiral 1000 2.070 3.049 327.976
sngl_burst 1 0.040 0.060 16.626
sngl_burst 10 0.050 0.058 171.054
sngl_burst 100 0.200 0.321 311.659
sngl_burst 1000 1.630 2.491 401.445
sngl_ringdown 1 0.030 0.064 15.723
sngl_ringdown 10 0.050 0.061 163.284
sngl_ringdown 100 0.210 0.299 334.389
sngl_ringdown 1000 1.670 2.694 371.195
sngl_unmodeled 1 0.030 0.040 25.186
sngl_unmodeled 10 0.060 0.070 143.608
sngl_unmodeled 100 0.300 0.487 205.188
sngl_unmodeled 1000 2.630 3.641 274.650
sngl_dperiodic 1 0.040 0.058 17.156
sngl_dperiodic 10 0.060 0.070 141.933
sngl_dperiodic 100 0.250 0.361 277.136
sngl_dperiodic 1000 2.210 3.203 312.207
multi_inspiral 1 0.030 0.061 16.399
multi_inspiral 10 0.070 0.069 143.928
multi_inspiral 100 0.220 0.335 298.854
multi_inspiral 1000 1.710 2.889 346.141
multi_burst 1 0.040 0.041 24.592
multi_burst 10 0.050 0.061 165.125
multi_burst 100 0.200 0.326 306.925
multi_burst 1000 1.690 2.862 349.406
frameset_loc 1 0.020 0.069 14.513
frameset_loc 10 0.050 0.070 141.943
frameset_loc 100 0.320 0.428 233.721
frameset_loc 1000 3.020 3.869 258.465
summ_value 1 0.040 0.083 12.109
summ_value 10 0.070 0.092 108.633
summ_value 100 0.360 0.471 212.405
summ_value 1000 3.270 4.226 236.630
summ_statistics 1 0.040 0.091 11.030
summ_statistics 10 0.060 0.075 132.675
summ_statistics 100 0.280 0.454 220.252
summ_statistics 1000 2.630 4.034 247.893
summ_spectrum 1 0.030 0.142 7.037
summ_spectrum 10 0.070 0.131 76.105
summ_spectrum 100 0.470 1.059 94.429
summ_spectrum 1000 4.200 10.156 98.464
summ_comment 1 0.040 0.085 11.766
summ_comment 10 0.080 0.100 99.675
summ_comment 100 0.440 0.572 174.797
summ_comment 1000 4.050 4.861 205.719
summ_csd 1 0.040 0.115 8.701
summ_csd 10 0.070 0.146 68.583
summ_csd 100 0.490 1.079 92.678
summ_csd 1000 4.430 9.748 102.585
sngl_transdata 1 0.030 0.098 10.216
sngl_transdata 10 0.070 0.149 67.258
sngl_transdata 100 0.490 1.254 79.745
sngl_transdata 1000 4.620 9.215 108.519
sngl_unmodeled_v 1 0.030 0.056 17.880
sngl_unmodeled_v 10 0.040 0.057 176.841
sngl_unmodeled_v 100 0.170 0.355 281.863
sngl_unmodeled_v 1000 1.490 2.739 365.097
coinc_sngl 1 0.060 0.098 10.171
coinc_sngl 10 0.090 0.125 79.921
coinc_sngl 100 0.470 0.591 169.107
coinc_sngl 1000 4.220 7.793 128.320
sngl_datasource 1 0.020 0.071 14.136
sngl_datasource 10 0.060 0.059 170.762
sngl_datasource 100 0.270 0.380 263.379
sngl_datasource 1000 2.510 3.354 298.151

Summary: