ldas-dev Database cit_test Insertion Rates
Test Period October 31 2000 12:30:00
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.020 0.083 12.102
process 10 0.060 0.108 92.664
process 100 0.370 0.522 191.551
process 1000 3.260 5.738 174.277
process_params 1 0.040 0.090 11.128
process_params 10 0.050 0.063 159.215
process_params 100 0.260 0.322 310.317
process_params 1000 2.300 3.357 297.885
frameset_chanlist 1 0.030 0.083 12.030
frameset_chanlist 10 0.040 0.083 120.549
frameset_chanlist 100 0.130 0.298 335.532
frameset_chanlist 1000 1.100 2.933 340.948
frameset_writer 1 0.030 0.045 22.098
frameset_writer 10 0.050 0.200 49.879
frameset_writer 100 0.330 0.609 164.098
frameset_writer 1000 2.760 5.115 195.503
segment_definer 1 0.030 0.057 17.520
segment_definer 10 0.050 0.081 123.344
segment_definer 100 0.220 0.493 202.985
segment_definer 1000 2.140 5.946 168.180
filter 1 0.030 0.049 20.270
filter 10 0.050 0.076 132.405
filter 100 0.170 0.363 275.419
filter 1000 1.530 4.036 247.770
frameset 1 0.020 0.111 8.993
frameset 10 0.040 0.079 127.337
frameset 100 0.230 0.291 343.185
frameset 1000 1.920 2.730 366.300
segment 1 0.050 0.068 14.683
segment 10 0.030 0.064 156.779
segment 100 0.130 0.209 479.471
segment 1000 0.970 1.595 626.959
filter_params 1 0.040 0.085 11.778
filter_params 10 0.050 0.061 163.870
filter_params 100 0.230 0.314 318.684
filter_params 1000 2.300 2.949 339.098
gds_trigger 1 0.060 0.138 7.253
gds_trigger 10 0.070 0.090 110.792
gds_trigger 100 0.350 0.760 131.559
gds_trigger 1000 3.130 10.732 93.179
sngl_inspiral 1 0.030 0.064 15.528
sngl_inspiral 10 0.060 0.092 108.154
sngl_inspiral 100 0.240 0.469 213.256
sngl_inspiral 1000 2.030 5.001 199.960
sngl_burst 1 0.030 0.068 14.762
sngl_burst 10 0.040 0.084 119.667
sngl_burst 100 0.200 0.399 250.574
sngl_burst 1000 1.590 5.011 199.561
sngl_ringdown 1 0.040 0.057 17.645
sngl_ringdown 10 0.050 0.074 135.084
sngl_ringdown 100 0.180 0.403 248.296
sngl_ringdown 1000 1.610 4.687 213.356
sngl_unmodeled 1 0.040 0.086 11.625
sngl_unmodeled 10 0.070 0.087 114.633
sngl_unmodeled 100 0.280 0.522 191.429
sngl_unmodeled 1000 2.540 5.641 177.274
sngl_dperiodic 1 0.060 0.063 15.771
sngl_dperiodic 10 0.060 0.091 110.181
sngl_dperiodic 100 0.240 0.482 207.625
sngl_dperiodic 1000 2.130 6.244 160.154
multi_inspiral 1 0.060 0.064 15.559
multi_inspiral 10 0.040 0.082 121.853
multi_inspiral 100 0.190 0.435 229.698
multi_inspiral 1000 1.680 4.530 220.751
multi_burst 1 0.040 0.066 15.191
multi_burst 10 0.050 0.061 162.999
multi_burst 100 0.190 0.426 234.748
multi_burst 1000 1.630 4.489 222.767
frameset_loc 1 0.030 0.143 7.008
frameset_loc 10 0.060 0.073 136.077
frameset_loc 100 0.310 0.510 196.270
frameset_loc 1000 2.820 6.778 147.536
summ_value 1 0.040 0.096 10.463
summ_value 10 0.060 0.136 73.683
summ_value 100 0.350 0.604 165.496
summ_value 1000 3.080 5.143 194.439
summ_statistics 1 0.060 0.105 9.513
summ_statistics 10 0.060 0.102 98.400
summ_statistics 100 0.290 0.549 182.139
summ_statistics 1000 2.480 6.089 164.231
summ_spectrum 1 0.030 0.142 7.038
summ_spectrum 10 0.070 0.218 45.923
summ_spectrum 100 0.450 2.250 44.444
summ_spectrum 1000 3.960 18.650 53.619
summ_comment 1 0.040 0.118 8.453
summ_comment 10 0.080 0.095 105.399
summ_comment 100 0.420 0.570 175.481
summ_comment 1000 3.890 6.010 166.389
sngl_transdata 1 0.030 0.080 12.448
sngl_transdata 10 0.050 0.192 51.956
sngl_transdata 100 0.480 2.122 47.125
sngl_transdata 1000 4.320 17.429 57.376
sngl_unmodeled_v 1 0.030 0.091 10.979
sngl_unmodeled_v 10 0.040 0.070 142.820
sngl_unmodeled_v 100 0.180 0.315 317.734
sngl_unmodeled_v 1000 1.400 3.169 315.557
coinc_sngl 1 0.050 0.149 6.723
coinc_sngl 10 0.090 0.186 53.629
coinc_sngl 100 0.450 0.983 101.734
coinc_sngl 1000 4.070 9.665 103.466
sngl_datasource 1 0.030 0.074 13.472
sngl_datasource 10 0.050 0.120 83.048
sngl_datasource 100 0.260 0.332 301.012
sngl_datasource 1000 2.350 2.872 348.189

Summary: