ldas-wa Database lho_test Insertion Rates
Test Period March 07 2001 13:02:51
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3461M free, 187M swap in use, 3153M swap free
LDAS software ldas-0.0.15, 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.040 0.079 12.725
process 10 0.070 0.120 83.608
process 100 0.360 0.507 197.077
process 1000 3.380 4.597 217.533
process_params 1 0.040 0.101 9.942
process_params 10 0.050 0.100 100.274
process_params 100 0.270 0.342 292.181
process_params 1000 2.410 3.153 317.158
frameset_chanlist 1 0.040 0.068 14.602
frameset_chanlist 10 0.030 0.120 83.633
frameset_chanlist 100 0.130 0.329 303.959
frameset_chanlist 1000 1.130 1.845 542.005
frameset_writer 1 0.010 0.063 15.910
frameset_writer 10 0.050 0.134 74.587
frameset_writer 100 0.310 0.534 187.111
frameset_writer 1000 2.880 5.474 182.682
segment_definer 1 0.020 0.060 16.563
segment_definer 10 0.050 0.128 78.359
segment_definer 100 0.290 0.518 192.989
segment_definer 1000 2.250 4.567 218.962
filter 1 0.030 0.077 13.023
filter 10 0.030 0.072 138.074
filter 100 0.180 0.372 269.065
filter 1000 1.570 3.181 314.367
frameset 1 0.030 0.098 10.158
frameset 10 0.060 0.123 81.037
frameset 100 0.220 0.394 254.079
frameset 1000 1.990 3.275 305.344
segment 1 0.020 0.062 16.030
segment 10 0.040 0.063 159.734
segment 100 0.110 0.272 367.068
segment 1000 1.030 1.778 562.430
filter_params 1 0.020 0.060 16.741
filter_params 10 0.050 0.096 103.669
filter_params 100 0.270 0.400 250.164
filter_params 1000 2.420 3.359 297.708
gds_trigger 1 0.060 0.084 11.960
gds_trigger 10 0.070 0.166 60.392
gds_trigger 100 0.340 0.660 151.542
gds_trigger 1000 3.210 12.127 82.461
sngl_inspiral 1 0.030 0.083 12.022
sngl_inspiral 10 0.070 0.129 77.560
sngl_inspiral 100 0.230 0.723 138.236
sngl_inspiral 1000 2.060 4.409 226.809
sngl_burst 1 0.020 0.076 13.245
sngl_burst 10 0.060 0.080 125.240
sngl_burst 100 0.190 0.388 258.033
sngl_burst 1000 1.650 3.545 282.087
sngl_ringdown 1 0.030 0.124 8.094
sngl_ringdown 10 0.050 0.143 70.100
sngl_ringdown 100 0.200 0.402 248.940
sngl_ringdown 1000 1.630 3.978 251.383
sngl_unmodeled 1 0.020 0.078 12.817
sngl_unmodeled 10 0.070 0.145 69.163
sngl_unmodeled 100 0.290 0.530 188.723
sngl_unmodeled 1000 2.630 5.025 199.005
sngl_dperiodic 1 0.050 0.090 11.146
sngl_dperiodic 10 0.070 0.135 73.854
sngl_dperiodic 100 0.260 0.504 198.449
sngl_dperiodic 1000 2.150 4.683 213.538
multi_inspiral 1 0.060 0.085 11.811
multi_inspiral 10 0.060 0.086 116.303
multi_inspiral 100 0.210 0.483 206.997
multi_inspiral 1000 1.700 4.035 247.831
multi_burst 1 0.030 0.078 12.826
multi_burst 10 0.050 0.105 95.418
multi_burst 100 0.240 0.480 208.311
multi_burst 1000 1.650 3.884 257.467
frameset_loc 1 0.030 0.100 10.026
frameset_loc 10 0.060 0.096 103.748
frameset_loc 100 0.320 0.544 183.939
frameset_loc 1000 2.940 4.778 209.293
summ_value 1 0.050 0.091 10.972
summ_value 10 0.060 0.161 61.920
summ_value 100 0.350 0.678 147.399
summ_value 1000 3.210 5.659 176.710
summ_statistics 1 0.050 0.081 12.322
summ_statistics 10 0.060 0.136 73.319
summ_statistics 100 0.300 0.619 161.595
summ_statistics 1000 2.580 5.759 173.641
summ_spectrum 1 0.030 0.109 9.134
summ_spectrum 10 0.060 0.431 23.206
summ_spectrum 100 0.450 4.572 21.872
summ_spectrum 1000 4.150 42.355 23.610
summ_comment 1 0.040 0.079 12.713
summ_comment 10 0.080 0.149 67.070
summ_comment 100 0.420 0.607 164.757
summ_comment 1000 4.120 5.341 187.231
summ_csd 1 0.040 0.121 8.260
summ_csd 10 0.070 0.414 24.171
summ_csd 100 0.510 4.569 21.887
summ_csd 1000 4.390 42.349 23.613
sngl_transdata 1 0.020 0.086 11.656
sngl_transdata 10 0.060 0.378 26.451
sngl_transdata 100 0.490 4.330 23.095
sngl_transdata 1000 4.630 40.146 24.909
sngl_unmodeled_v 1 0.030 0.084 11.842
sngl_unmodeled_v 10 0.040 0.131 76.554
sngl_unmodeled_v 100 0.170 0.351 285.151
sngl_unmodeled_v 1000 1.500 3.211 311.429
coinc_sngl 1 0.050 0.126 7.912
coinc_sngl 10 0.090 0.207 48.395
coinc_sngl 100 0.450 0.998 100.189
coinc_sngl 1000 4.220 10.179 98.241
sngl_datasource 1 0.030 0.079 12.630
sngl_datasource 10 0.050 0.128 77.965
sngl_datasource 100 0.270 0.372 268.545
sngl_datasource 1000 2.480 3.172 315.259

Summary: