ldas-dev Database cit_test Insertion Rates
Test Period November 04 2000 22:56:57
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.12, 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.050 0.105 9.516
process 10 0.070 0.108 92.797
process 100 0.350 0.527 189.810
process 1000 3.250 5.267 189.861
process_params 1 0.040 0.093 10.717
process_params 10 0.050 0.092 109.091
process_params 100 0.260 0.333 300.738
process_params 1000 2.300 2.884 346.741
frameset_chanlist 1 0.030 0.036 27.601
frameset_chanlist 10 0.040 0.053 188.505
frameset_chanlist 100 0.140 0.264 378.636
frameset_chanlist 1000 1.100 2.954 338.524
frameset_writer 1 0.020 0.044 22.763
frameset_writer 10 0.060 0.077 129.037
frameset_writer 100 0.300 0.530 188.607
frameset_writer 1000 2.790 4.742 210.881
segment_definer 1 0.020 0.034 29.600
segment_definer 10 0.060 0.074 134.876
segment_definer 100 0.260 0.447 223.758
segment_definer 1000 2.140 3.752 266.525
filter 1 0.030 0.041 24.671
filter 10 0.050 0.095 105.067
filter 100 0.180 0.401 249.626
filter 1000 1.520 4.062 246.184
frameset 1 0.040 0.281 3.563
frameset 10 0.040 0.091 109.919
frameset 100 0.230 0.314 318.081
frameset 1000 1.890 3.252 307.503
segment 1 0.020 0.058 17.161
segment 10 0.030 0.058 173.019
segment 100 0.120 0.190 527.398
segment 1000 0.960 1.584 631.313
filter_params 1 0.050 0.074 13.452
filter_params 10 0.050 0.083 120.750
filter_params 100 0.250 0.300 333.601
filter_params 1000 2.280 2.840 352.113
gds_trigger 1 0.040 0.101 9.862
gds_trigger 10 0.060 0.100 100.487
gds_trigger 100 0.330 0.715 139.929
gds_trigger 1000 3.130 10.647 93.923
sngl_inspiral 1 0.050 0.080 12.505
sngl_inspiral 10 0.060 0.073 136.717
sngl_inspiral 100 0.240 0.562 177.899
sngl_inspiral 1000 2.000 5.153 194.062
sngl_burst 1 0.040 0.051 19.452
sngl_burst 10 0.050 0.084 118.971
sngl_burst 100 0.200 0.410 244.066
sngl_burst 1000 1.600 4.445 224.972
sngl_ringdown 1 0.040 0.091 10.974
sngl_ringdown 10 0.050 0.204 49.020
sngl_ringdown 100 0.190 0.412 242.738
sngl_ringdown 1000 1.600 4.182 239.120
sngl_unmodeled 1 0.040 0.080 12.542
sngl_unmodeled 10 0.070 0.086 116.903
sngl_unmodeled 100 0.290 0.539 185.671
sngl_unmodeled 1000 2.550 5.475 182.648
sngl_dperiodic 1 0.040 0.077 12.957
sngl_dperiodic 10 0.060 0.079 125.959
sngl_dperiodic 100 0.250 0.527 189.932
sngl_dperiodic 1000 2.100 5.640 177.305
multi_inspiral 1 0.030 0.067 15.032
multi_inspiral 10 0.050 0.098 101.978
multi_inspiral 100 0.190 0.457 218.655
multi_inspiral 1000 1.680 5.269 189.789
multi_burst 1 0.030 0.067 15.035
multi_burst 10 0.070 0.081 123.422
multi_burst 100 0.200 0.437 229.065
multi_burst 1000 1.610 5.074 197.083
frameset_loc 1 0.030 0.123 8.163
frameset_loc 10 0.060 0.077 129.086
frameset_loc 100 0.320 0.497 201.181
frameset_loc 1000 2.800 6.844 146.113
summ_value 1 0.050 0.096 10.393
summ_value 10 0.090 0.152 65.610
summ_value 100 0.350 0.607 164.803
summ_value 1000 3.070 5.034 198.649
summ_statistics 1 0.040 0.109 9.214
summ_statistics 10 0.060 0.103 97.285
summ_statistics 100 0.280 0.561 178.231
summ_statistics 1000 2.490 5.398 185.254
summ_spectrum 1 0.030 0.112 8.935
summ_spectrum 10 0.070 0.205 48.802
summ_spectrum 100 0.430 2.164 46.211
summ_spectrum 1000 3.980 18.656 53.602
summ_comment 1 0.040 0.108 9.218
summ_comment 10 0.070 0.094 106.066
summ_comment 100 0.430 0.620 161.207
summ_comment 1000 3.910 6.440 155.280
sngl_transdata 1 0.020 0.107 9.324
sngl_transdata 10 0.070 0.179 55.763
sngl_transdata 100 0.470 3.272 30.562
sngl_transdata 1000 4.330 17.402 57.465
sngl_unmodeled_v 1 0.020 0.073 13.749
sngl_unmodeled_v 10 0.040 0.067 148.364
sngl_unmodeled_v 100 0.160 0.267 375.130
sngl_unmodeled_v 1000 1.410 3.108 321.750
coinc_sngl 1 0.050 0.095 10.574
coinc_sngl 10 0.090 0.190 52.613
coinc_sngl 100 0.450 1.186 84.317
coinc_sngl 1000 4.080 10.684 93.598
sngl_datasource 1 0.030 0.084 11.863
sngl_datasource 10 0.050 0.059 168.186
sngl_datasource 100 0.270 0.333 300.554
sngl_datasource 1000 2.350 3.051 327.761

Summary: