ldas-test Database cprod_t Insertion Rates
Test Period February 22 2001 14:15:17
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3095M free, 220M swap in use, 3019M swap free
LDAS software ldas-0.0.14, 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.040 0.067 15.019
process 10 0.070 0.098 102.316
process 100 0.370 0.465 214.860
process 1000 3.430 4.342 230.309
process_params 1 0.040 0.070 14.297
process_params 10 0.040 0.087 115.067
process_params 100 0.290 0.382 261.868
process_params 1000 2.430 2.918 342.700
frameset_chanlist 1 0.030 0.062 16.080
frameset_chanlist 10 0.040 0.061 163.071
frameset_chanlist 100 0.130 0.256 389.927
frameset_chanlist 1000 1.130 1.636 611.247
frameset_writer 1 0.020 0.088 11.407
frameset_writer 10 0.050 0.091 110.370
frameset_writer 100 0.320 0.495 202.144
frameset_writer 1000 2.920 4.179 239.292
segment_definer 1 0.020 0.059 16.947
segment_definer 10 0.050 0.107 93.547
segment_definer 100 0.260 0.404 247.288
segment_definer 1000 2.290 3.438 290.867
filter 1 0.030 0.061 16.430
filter 10 0.040 0.091 110.005
filter 100 0.200 0.310 322.107
filter 1000 1.640 2.579 387.747
frameset 1 0.030 0.095 10.521
frameset 10 0.050 0.089 112.085
frameset 100 0.230 0.352 284.159
frameset 1000 2.040 2.552 391.850
segment 1 0.020 0.067 14.973
segment 10 0.030 0.085 117.624
segment 100 0.120 0.228 439.207
segment 1000 1.040 1.467 681.663
filter_params 1 0.020 0.055 18.038
filter_params 10 0.050 0.070 142.935
filter_params 100 0.260 0.374 267.127
filter_params 1000 2.450 2.873 348.068
gds_trigger 1 0.040 0.080 12.450
gds_trigger 10 0.080 0.115 86.819
gds_trigger 100 0.340 0.592 168.983
gds_trigger 1000 3.240 7.914 126.358
sngl_inspiral 1 0.030 0.081 12.270
sngl_inspiral 10 0.060 0.107 93.386
sngl_inspiral 100 0.250 0.377 265.221
sngl_inspiral 1000 2.070 3.518 284.252
sngl_burst 1 0.030 0.087 11.467
sngl_burst 10 0.050 0.098 102.122
sngl_burst 100 0.190 0.338 295.720
sngl_burst 1000 1.640 2.802 356.888
sngl_ringdown 1 0.030 0.076 13.091
sngl_ringdown 10 0.050 0.072 139.427
sngl_ringdown 100 0.210 0.314 318.647
sngl_ringdown 1000 1.650 2.928 341.530
sngl_unmodeled 1 0.060 0.117 8.513
sngl_unmodeled 10 0.070 0.093 107.628
sngl_unmodeled 100 0.290 0.414 241.821
sngl_unmodeled 1000 2.640 3.948 253.293
sngl_dperiodic 1 0.040 0.091 10.949
sngl_dperiodic 10 0.060 0.114 88.037
sngl_dperiodic 100 0.250 0.418 239.072
sngl_dperiodic 1000 2.200 3.763 265.745
multi_inspiral 1 0.030 0.086 11.634
multi_inspiral 10 0.060 0.103 97.125
multi_inspiral 100 0.230 0.430 232.377
multi_inspiral 1000 1.750 3.149 317.561
multi_burst 1 0.040 0.074 13.471
multi_burst 10 0.050 0.099 101.171
multi_burst 100 0.210 0.328 305.147
multi_burst 1000 1.690 3.189 313.578
frameset_loc 1 0.030 0.061 16.388
frameset_loc 10 0.060 0.103 97.113
frameset_loc 100 0.310 0.501 199.411
frameset_loc 1000 3.010 4.179 239.292
summ_value 1 0.030 0.071 14.032
summ_value 10 0.080 0.113 88.554
summ_value 100 0.360 0.562 177.844
summ_value 1000 3.260 4.580 218.341
summ_statistics 1 0.030 0.076 13.096
summ_statistics 10 0.070 0.110 91.051
summ_statistics 100 0.290 0.494 202.249
summ_statistics 1000 2.630 4.406 226.963
summ_spectrum 1 0.070 0.121 8.267
summ_spectrum 10 0.060 0.211 47.316
summ_spectrum 100 0.470 2.351 42.535
summ_spectrum 1000 4.160 20.740 48.216
summ_comment 1 0.050 0.081 12.283
summ_comment 10 0.080 0.126 79.483
summ_comment 100 0.450 0.548 182.536
summ_comment 1000 4.060 4.917 203.376
sngl_transdata 1 0.030 0.078 12.813
sngl_transdata 10 0.070 0.221 45.313
sngl_transdata 100 0.490 2.308 43.328
sngl_transdata 1000 4.590 20.203 49.498
sngl_unmodeled_v 1 0.030 0.066 15.134
sngl_unmodeled_v 10 0.050 0.067 148.863
sngl_unmodeled_v 100 0.160 0.246 407.201
sngl_unmodeled_v 1000 1.500 2.607 383.583
coinc_sngl 1 0.040 0.138 7.247
coinc_sngl 10 0.090 0.154 64.929
coinc_sngl 100 0.450 0.772 129.492
coinc_sngl 1000 4.250 7.701 129.853
sngl_datasource 1 0.020 0.064 15.746
sngl_datasource 10 0.050 0.081 124.077
sngl_datasource 100 0.280 0.364 274.928
sngl_datasource 1000 2.510 3.005 332.779

Summary: