ldas-dev Database cit_test Insertion Rates
Test Period February 22 2001 18:19:11
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-5_10
Memory: 256M real, 64M free, 185M swap in use, 1002M swap free
LDAS software ldas-0.0.14, 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.020 0.091 11.047
process 10 0.060 0.071 140.922
process 100 0.360 0.490 203.985
process 1000 3.280 4.596 217.581
process_params 1 0.040 0.050 19.907
process_params 10 0.050 0.060 166.027
process_params 100 0.250 0.308 324.682
process_params 1000 2.360 2.916 342.936
frameset_chanlist 1 0.030 0.056 17.930
frameset_chanlist 10 0.050 0.077 130.613
frameset_chanlist 100 0.140 0.207 483.929
frameset_chanlist 1000 1.140 1.934 517.063
frameset_writer 1 0.060 0.094 10.674
frameset_writer 10 0.050 0.062 160.475
frameset_writer 100 0.320 0.423 236.508
frameset_writer 1000 2.810 3.524 283.768
segment_definer 1 0.020 0.062 16.120
segment_definer 10 0.050 0.065 152.898
segment_definer 100 0.250 0.401 249.334
segment_definer 1000 2.200 3.033 329.707
filter 1 0.010 0.032 30.944
filter 10 0.040 0.060 167.563
filter 100 0.170 0.225 444.969
filter 1000 1.550 2.669 374.672
frameset 1 0.060 0.091 11.037
frameset 10 0.040 0.074 135.437
frameset 100 0.240 0.358 279.646
frameset 1000 1.970 2.860 349.650
segment 1 0.020 0.070 14.376
segment 10 0.030 0.061 164.514
segment 100 0.120 0.239 418.790
segment 1000 1.000 1.390 719.424
filter_params 1 0.030 0.064 15.721
filter_params 10 0.050 0.054 184.451
filter_params 100 0.250 0.343 291.711
filter_params 1000 2.350 2.906 344.116
gds_trigger 1 0.040 0.102 9.824
gds_trigger 10 0.050 0.110 90.499
gds_trigger 100 0.330 0.496 201.683
gds_trigger 1000 3.190 5.794 172.592
sngl_inspiral 1 0.040 0.106 9.431
sngl_inspiral 10 0.060 0.105 95.087
sngl_inspiral 100 0.240 0.359 278.820
sngl_inspiral 1000 2.010 3.362 297.442
sngl_burst 1 0.020 0.090 11.111
sngl_burst 10 0.050 0.076 131.648
sngl_burst 100 0.190 0.284 351.979
sngl_burst 1000 1.620 2.829 353.482
sngl_ringdown 1 0.040 0.077 12.955
sngl_ringdown 10 0.050 0.061 164.848
sngl_ringdown 100 0.180 0.265 377.149
sngl_ringdown 1000 1.630 2.902 344.590
sngl_unmodeled 1 0.030 0.080 12.440
sngl_unmodeled 10 0.050 0.075 132.473
sngl_unmodeled 100 0.270 0.479 208.933
sngl_unmodeled 1000 2.570 3.520 284.091
sngl_dperiodic 1 0.040 0.087 11.513
sngl_dperiodic 10 0.060 0.077 129.356
sngl_dperiodic 100 0.260 0.467 214.140
sngl_dperiodic 1000 2.150 4.155 240.674
multi_inspiral 1 0.040 0.081 12.395
multi_inspiral 10 0.050 0.073 136.147
multi_inspiral 100 0.200 0.334 299.834
multi_inspiral 1000 1.660 3.041 328.839
multi_burst 1 0.030 0.232 4.317
multi_burst 10 0.050 0.069 145.233
multi_burst 100 0.200 0.320 312.440
multi_burst 1000 1.660 2.562 390.320
frameset_loc 1 0.030 0.766 1.306
frameset_loc 10 0.050 0.070 142.195
frameset_loc 100 0.310 0.442 226.198
frameset_loc 1000 2.880 3.825 261.438
summ_value 1 0.050 0.127 7.893
summ_value 10 0.050 0.073 136.842
summ_value 100 0.350 0.509 196.579
summ_value 1000 3.130 4.415 226.501
summ_statistics 1 0.040 0.146 6.842
summ_statistics 10 0.070 0.078 128.942
summ_statistics 100 0.270 0.528 189.391
summ_statistics 1000 2.520 4.310 232.019
summ_spectrum 1 0.030 0.159 6.277
summ_spectrum 10 0.060 0.163 61.533
summ_spectrum 100 0.450 1.155 86.580
summ_spectrum 1000 4.110 8.984 111.309
summ_comment 1 0.050 0.157 6.356
summ_comment 10 0.070 0.093 107.269
summ_comment 100 0.420 0.483 207.111
summ_comment 1000 3.910 5.449 183.520
sngl_transdata 1 0.020 0.100 10.048
sngl_transdata 10 0.070 0.165 60.589
sngl_transdata 100 0.500 1.125 88.889
sngl_transdata 1000 4.450 10.566 94.643
sngl_unmodeled_v 1 0.020 0.109 9.216
sngl_unmodeled_v 10 0.050 0.063 158.275
sngl_unmodeled_v 100 0.160 0.285 351.274
sngl_unmodeled_v 1000 1.420 2.837 352.485
coinc_sngl 1 0.050 0.273 3.667
coinc_sngl 10 0.090 0.138 72.568
coinc_sngl 100 0.450 0.581 172.119
coinc_sngl 1000 4.140 7.742 129.166
sngl_datasource 1 0.040 0.095 10.509
sngl_datasource 10 0.050 0.056 177.230
sngl_datasource 100 0.280 0.359 278.784
sngl_datasource 1000 2.410 3.246 308.071

Summary: