ldas-test Database cprod_t Insertion Rates
Test Period January 11 2001 11:55:02
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3695M free, 65M swap in use, 3318M swap free
LDAS software ldas-0.0.12, 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.068 14.770
process 10 0.070 0.104 96.463
process 100 0.350 0.470 212.690
process 1000 3.310 4.311 231.965
process_params 1 0.040 0.098 10.211
process_params 10 0.050 0.087 114.998
process_params 100 0.260 0.352 284.465
process_params 1000 2.340 2.833 352.983
frameset_chanlist 1 0.020 0.070 14.206
frameset_chanlist 10 0.040 0.072 138.118
frameset_chanlist 100 0.150 0.244 409.536
frameset_chanlist 1000 1.140 1.607 622.278
frameset_writer 1 0.030 0.056 17.982
frameset_writer 10 0.050 0.086 116.081
frameset_writer 100 0.300 0.492 203.210
frameset_writer 1000 2.830 4.049 246.975
segment_definer 1 0.020 0.058 17.159
segment_definer 10 0.050 0.090 111.303
segment_definer 100 0.240 0.391 255.658
segment_definer 1000 2.190 3.485 286.944
filter 1 0.030 0.061 16.524
filter 10 0.070 0.117 85.540
filter 100 0.180 0.301 332.463
filter 1000 1.540 2.513 397.931
frameset 1 0.030 0.073 13.707
frameset 10 0.050 0.102 98.170
frameset 100 0.220 0.313 319.820
frameset 1000 1.960 2.665 375.235
segment 1 0.020 0.061 16.293
segment 10 0.050 0.091 109.776
segment 100 0.120 0.225 444.490
segment 1000 1.000 1.642 609.013
filter_params 1 0.030 0.074 13.427
filter_params 10 0.050 0.072 138.299
filter_params 100 0.270 0.332 300.990
filter_params 1000 2.330 2.810 355.872
gds_trigger 1 0.050 0.107 9.312
gds_trigger 10 0.060 0.112 88.996
gds_trigger 100 0.340 0.530 188.514
gds_trigger 1000 3.150 7.355 135.962
sngl_inspiral 1 0.040 0.086 11.676
sngl_inspiral 10 0.070 0.121 82.400
sngl_inspiral 100 0.240 0.395 253.288
sngl_inspiral 1000 2.030 3.128 319.693
sngl_burst 1 0.030 0.065 15.302
sngl_burst 10 0.050 0.106 94.747
sngl_burst 100 0.210 0.329 303.851
sngl_burst 1000 1.640 2.849 351.000
sngl_ringdown 1 0.040 0.074 13.431
sngl_ringdown 10 0.060 0.077 129.071
sngl_ringdown 100 0.210 0.302 330.722
sngl_ringdown 1000 1.640 2.857 350.018
sngl_unmodeled 1 0.030 0.073 13.685
sngl_unmodeled 10 0.050 0.093 107.659
sngl_unmodeled 100 0.310 0.459 217.771
sngl_unmodeled 1000 2.680 3.885 257.400
sngl_dperiodic 1 0.030 0.085 11.769
sngl_dperiodic 10 0.060 0.102 98.407
sngl_dperiodic 100 0.250 0.504 198.338
sngl_dperiodic 1000 2.170 3.578 279.486
multi_inspiral 1 0.050 0.074 13.504
multi_inspiral 10 0.050 0.104 95.986
multi_inspiral 100 0.210 0.344 290.503
multi_inspiral 1000 1.670 3.114 321.130
multi_burst 1 0.040 0.083 12.049
multi_burst 10 0.050 0.084 119.453
multi_burst 100 0.200 0.344 290.771
multi_burst 1000 1.710 3.134 319.081
frameset_loc 1 0.040 0.070 14.257
frameset_loc 10 0.050 0.089 112.604
frameset_loc 100 0.320 0.483 207.214
frameset_loc 1000 2.850 3.938 253.936
summ_value 1 0.050 0.089 11.241
summ_value 10 0.060 0.107 93.421
summ_value 100 0.340 0.525 190.390
summ_value 1000 3.140 4.397 227.428
summ_statistics 1 0.020 0.081 12.368
summ_statistics 10 0.070 0.108 92.722
summ_statistics 100 0.300 0.464 215.668
summ_statistics 1000 2.550 4.567 218.962
summ_spectrum 1 0.040 0.120 8.348
summ_spectrum 10 0.070 0.228 43.888
summ_spectrum 100 0.440 2.278 43.898
summ_spectrum 1000 4.000 20.680 48.356
summ_comment 1 0.040 0.099 10.086
summ_comment 10 0.080 0.102 98.143
summ_comment 100 0.430 0.539 185.657
summ_comment 1000 3.910 4.623 216.310
sngl_transdata 1 0.040 0.079 12.736
sngl_transdata 10 0.070 0.289 34.553
sngl_transdata 100 0.490 2.273 43.995
sngl_transdata 1000 4.420 20.153 49.620
sngl_unmodeled_v 1 0.020 0.055 18.057
sngl_unmodeled_v 10 0.030 0.093 107.996
sngl_unmodeled_v 100 0.190 0.280 356.515
sngl_unmodeled_v 1000 1.470 2.439 410.004
coinc_sngl 1 0.060 0.129 7.730
coinc_sngl 10 0.080 0.189 53.023
coinc_sngl 100 0.450 0.737 135.719
coinc_sngl 1000 4.160 7.441 134.391
sngl_datasource 1 0.030 0.060 16.728
sngl_datasource 10 0.050 0.071 140.021
sngl_datasource 100 0.270 0.362 276.346
sngl_datasource 1000 2.420 2.849 351.000

Summary: