ldas-wa Database lho_test Insertion Rates
Test Period November 04 2000 22:59:41
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.030 0.073 13.732
process 10 0.080 0.111 90.384
process 100 0.370 0.500 200.185
process 1000 3.340 5.180 193.050
process_params 1 0.040 0.091 10.999
process_params 10 0.060 0.096 104.470
process_params 100 0.260 0.325 308.092
process_params 1000 2.330 2.740 364.964
frameset_chanlist 1 0.020 0.052 19.308
frameset_chanlist 10 0.040 0.058 173.551
frameset_chanlist 100 0.130 0.283 353.683
frameset_chanlist 1000 1.140 2.874 347.947
frameset_writer 1 0.040 0.053 18.957
frameset_writer 10 0.050 0.089 112.225
frameset_writer 100 0.300 0.497 201.044
frameset_writer 1000 2.860 4.227 236.574
segment_definer 1 0.020 0.176 5.668
segment_definer 10 0.050 0.085 117.802
segment_definer 100 0.230 0.384 260.278
segment_definer 1000 2.200 3.667 272.702
filter 1 0.030 0.056 17.789
filter 10 0.070 0.092 108.614
filter 100 0.190 0.499 200.512
filter 1000 1.560 3.917 255.297
frameset 1 0.060 0.103 9.743
frameset 10 0.050 0.087 114.786
frameset 100 0.210 0.282 354.509
frameset 1000 1.920 2.593 385.654
segment 1 0.020 0.050 19.955
segment 10 0.030 0.076 131.775
segment 100 0.120 0.182 549.067
segment 1000 0.990 1.418 705.219
filter_params 1 0.020 0.124 8.059
filter_params 10 0.050 0.064 157.478
filter_params 100 0.260 0.305 327.653
filter_params 1000 2.330 2.730 366.300
gds_trigger 1 0.040 0.071 14.111
gds_trigger 10 0.070 0.094 106.923
gds_trigger 100 0.340 0.640 156.149
gds_trigger 1000 3.200 9.738 102.690
sngl_inspiral 1 0.030 0.079 12.710
sngl_inspiral 10 0.060 0.092 108.791
sngl_inspiral 100 0.240 0.499 200.305
sngl_inspiral 1000 2.070 4.611 216.873
sngl_burst 1 0.040 0.076 13.147
sngl_burst 10 0.050 0.087 115.046
sngl_burst 100 0.180 0.387 258.272
sngl_burst 1000 1.640 4.041 247.463
sngl_ringdown 1 0.030 0.071 14.122
sngl_ringdown 10 0.060 0.071 141.633
sngl_ringdown 100 0.180 0.375 266.736
sngl_ringdown 1000 1.670 4.464 224.014
sngl_unmodeled 1 0.030 0.065 15.453
sngl_unmodeled 10 0.070 0.091 109.576
sngl_unmodeled 100 0.300 0.532 187.905
sngl_unmodeled 1000 2.640 5.417 184.604
sngl_dperiodic 1 0.030 0.067 14.839
sngl_dperiodic 10 0.090 0.116 85.950
sngl_dperiodic 100 0.250 0.458 218.182
sngl_dperiodic 1000 2.140 5.390 185.529
multi_inspiral 1 0.060 0.073 13.737
multi_inspiral 10 0.060 0.094 106.541
multi_inspiral 100 0.210 0.396 252.256
multi_inspiral 1000 1.710 4.355 229.621
multi_burst 1 0.040 0.064 15.615
multi_burst 10 0.060 0.071 140.302
multi_burst 100 0.210 0.397 251.689
multi_burst 1000 1.690 4.175 239.521
frameset_loc 1 0.030 0.095 10.550
frameset_loc 10 0.050 0.083 121.004
frameset_loc 100 0.310 0.501 199.496
frameset_loc 1000 2.910 6.027 165.920
summ_value 1 0.040 0.082 12.200
summ_value 10 0.070 0.097 102.892
summ_value 100 0.340 0.520 192.175
summ_value 1000 3.180 4.746 210.704
summ_statistics 1 0.040 0.082 12.253
summ_statistics 10 0.070 0.095 105.310
summ_statistics 100 0.280 0.552 181.142
summ_statistics 1000 2.540 4.578 218.436
summ_spectrum 1 0.030 0.087 11.535
summ_spectrum 10 0.060 0.185 53.918
summ_spectrum 100 0.430 1.659 60.277
summ_spectrum 1000 4.190 15.089 66.273
summ_comment 1 0.030 0.067 15.017
summ_comment 10 0.070 0.123 81.025
summ_comment 100 0.430 0.568 176.010
summ_comment 1000 3.980 5.859 170.678
sngl_transdata 1 0.020 0.076 13.208
sngl_transdata 10 0.060 0.177 56.451
sngl_transdata 100 0.490 1.551 64.475
sngl_transdata 1000 4.420 14.204 70.403
sngl_unmodeled_v 1 0.030 0.057 17.600
sngl_unmodeled_v 10 0.040 0.062 160.439
sngl_unmodeled_v 100 0.180 0.293 340.750
sngl_unmodeled_v 1000 1.430 3.045 328.407
coinc_sngl 1 0.060 0.128 7.788
coinc_sngl 10 0.080 0.181 55.122
coinc_sngl 100 0.460 0.911 109.797
coinc_sngl 1000 4.170 9.173 109.016
sngl_datasource 1 0.040 0.096 10.465
sngl_datasource 10 0.070 0.083 120.837
sngl_datasource 100 0.270 0.308 324.662
sngl_datasource 1000 2.410 2.673 374.111

Summary: