ldas-wa Database lho_test Insertion Rates
Test Period October 31 2000 15:32:40
Input data Ilwd with dimensions 1,10,100,1000
Platform metaserver.ligo.caltech.edu (SUN 450, 4 CPUs, RAM=1024MB, Solaris 2.7)
LDAS software ldas-0.0.11, IBM DB2 6.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.062 16.249
process 10 0.080 0.101 99.294
process 100 0.370 0.494 202.343
process 1000 3.340 5.249 190.512
process_params 1 0.040 0.116 8.608
process_params 10 0.050 0.071 141.068
process_params 100 0.270 0.323 309.739
process_params 1000 2.410 2.825 353.982
frameset_chanlist 1 0.020 0.054 18.688
frameset_chanlist 10 0.040 0.066 150.957
frameset_chanlist 100 0.130 0.287 348.758
frameset_chanlist 1000 1.130 2.896 345.304
frameset_writer 1 0.030 0.050 19.902
frameset_writer 10 0.050 0.090 111.256
frameset_writer 100 0.340 0.522 191.418
frameset_writer 1000 2.880 4.280 233.645
segment_definer 1 0.030 0.066 15.209
segment_definer 10 0.040 0.090 111.246
segment_definer 100 0.250 0.393 254.417
segment_definer 1000 2.230 3.759 266.028
filter 1 0.040 0.059 17.026
filter 10 0.050 0.078 127.518
filter 100 0.180 0.399 250.525
filter 1000 1.590 3.905 256.082
frameset 1 0.060 0.130 7.674
frameset 10 0.050 0.070 143.526
frameset 100 0.220 0.293 341.623
frameset 1000 1.960 3.279 304.971
segment 1 0.020 0.051 19.799
segment 10 0.030 0.055 181.215
segment 100 0.140 0.210 475.679
segment 1000 1.010 1.431 698.812
filter_params 1 0.030 0.066 15.142
filter_params 10 0.050 0.090 111.054
filter_params 100 0.270 0.316 316.186
filter_params 1000 2.350 2.762 362.056
gds_trigger 1 0.030 0.086 11.640
gds_trigger 10 0.080 0.111 89.918
gds_trigger 100 0.350 0.654 153.014
gds_trigger 1000 3.220 9.418 106.180
sngl_inspiral 1 0.050 0.073 13.777
sngl_inspiral 10 0.060 0.077 130.400
sngl_inspiral 100 0.240 0.470 212.674
sngl_inspiral 1000 2.080 4.635 215.750
sngl_burst 1 0.040 0.069 14.439
sngl_burst 10 0.040 0.074 135.864
sngl_burst 100 0.200 0.419 238.668
sngl_burst 1000 1.650 4.192 238.550
sngl_ringdown 1 0.030 0.080 12.551
sngl_ringdown 10 0.050 0.090 110.760
sngl_ringdown 100 0.200 0.381 262.431
sngl_ringdown 1000 1.670 4.497 222.370
sngl_unmodeled 1 0.030 0.070 14.240
sngl_unmodeled 10 0.060 0.081 123.128
sngl_unmodeled 100 0.290 0.479 208.931
sngl_unmodeled 1000 2.630 5.395 185.357
sngl_dperiodic 1 0.050 0.071 14.065
sngl_dperiodic 10 0.060 0.090 111.355
sngl_dperiodic 100 0.250 0.506 197.593
sngl_dperiodic 1000 2.150 5.445 183.655
multi_inspiral 1 0.060 0.086 11.658
multi_inspiral 10 0.060 0.103 97.502
multi_inspiral 100 0.200 0.410 243.683
multi_inspiral 1000 1.760 4.451 224.669
multi_burst 1 0.030 0.083 12.030
multi_burst 10 0.050 0.093 107.053
multi_burst 100 0.190 0.409 244.321
multi_burst 1000 1.680 4.239 235.905
frameset_loc 1 0.030 0.103 9.685
frameset_loc 10 0.060 0.090 111.598
frameset_loc 100 0.310 0.510 196.115
frameset_loc 1000 2.880 6.626 150.921
summ_value 1 0.040 0.061 16.482
summ_value 10 0.080 0.093 107.775
summ_value 100 0.350 0.570 175.487
summ_value 1000 3.210 4.753 210.393
summ_statistics 1 0.040 0.070 14.228
summ_statistics 10 0.060 0.101 99.053
summ_statistics 100 0.290 0.511 195.650
summ_statistics 1000 2.550 4.663 214.454
summ_spectrum 1 0.060 0.128 7.791
summ_spectrum 10 0.070 0.187 53.618
summ_spectrum 100 0.450 1.667 59.988
summ_spectrum 1000 4.070 14.618 68.409
summ_comment 1 0.040 0.091 10.970
summ_comment 10 0.080 0.098 101.598
summ_comment 100 0.430 0.581 172.245
summ_comment 1000 3.960 5.838 171.292
sngl_transdata 1 0.040 0.087 11.539
sngl_transdata 10 0.070 0.183 54.774
sngl_transdata 100 0.500 1.538 65.020
sngl_transdata 1000 4.450 13.962 71.623
sngl_unmodeled_v 1 0.030 0.062 16.183
sngl_unmodeled_v 10 0.050 0.083 119.862
sngl_unmodeled_v 100 0.170 0.285 350.401
sngl_unmodeled_v 1000 1.450 2.949 339.098
coinc_sngl 1 0.050 0.126 7.960
coinc_sngl 10 0.080 0.188 53.314
coinc_sngl 100 0.470 0.923 108.338
coinc_sngl 1000 4.220 9.122 109.625
sngl_datasource 1 0.030 0.086 11.635
sngl_datasource 10 0.060 0.073 137.836
sngl_datasource 100 0.280 0.317 315.188
sngl_datasource 1000 2.430 2.704 369.822

Summary: