ldas-dev Database cit_1 Insertion Rates
Test Period April 15 2002 12:18:05
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3066M free, 840M swap in use, 2436M swap free
LDAS software ldas-0.1.97, 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.010 0.114 8.788
process 10 0.020 1.038 9.634
process 100 0.060 1.091 91.659
process 1000 1.590 1.578 633.714
runlist 1 0.010 1.024 0.977
runlist 10 0.090 1.095 9.132
runlist 100 0.020 1.020 98.039
runlist 1000 0.090 1.045 956.938
process_params 1 0.030 1.047 0.955
process_params 10 0.030 1.038 9.634
process_params 100 0.110 0.147 680.180
process_params 1000 0.140 1.076 929.368
frameset_chanlist 1 0.030 0.332 3.012
frameset_chanlist 10 0.040 0.058 170.990
frameset_chanlist 100 0.080 0.312 320.422
frameset_chanlist 1000 0.510 1.544 647.668
frameset_writer 1 0.110 1.133 0.883
frameset_writer 10 0.030 0.635 15.745
frameset_writer 100 0.380 0.808 123.747
frameset_writer 1000 0.160 1.116 896.057
segment_definer 1 0.090 1.140 0.877
segment_definer 10 0.030 0.168 59.421
segment_definer 100 0.340 0.352 283.933
segment_definer 1000 0.140 1.083 923.361
filter 1 0.030 1.052 0.951
filter 10 0.040 0.553 18.088
filter 100 0.350 1.089 91.827
filter 1000 0.510 1.504 664.894
search_summary 1 0.100 1.137 0.880
search_summary 10 0.040 0.175 57.083
search_summary 100 0.050 1.052 95.057
search_summary 1000 0.190 1.100 909.091
frameset 1 0.030 1.058 0.945
frameset 10 0.040 0.413 24.230
frameset 100 0.150 1.046 95.602
frameset 1000 0.890 1.091 916.590
segment 1 0.230 1.055 0.948
segment 10 0.030 0.067 148.480
segment 100 0.030 1.043 95.877
segment 1000 0.100 1.059 944.287
filter_params 1 0.030 0.581 1.722
filter_params 10 0.040 0.421 23.750
filter_params 100 0.050 0.656 152.466
filter_params 1000 0.170 1.093 914.913
sngl_inspiral 1 0.050 0.170 5.895
sngl_inspiral 10 0.050 1.062 9.416
sngl_inspiral 100 0.120 1.141 87.642
sngl_inspiral 1000 0.640 1.569 637.349
sngl_burst 1 0.040 1.062 0.942
sngl_burst 10 0.050 0.451 22.151
sngl_burst 100 0.270 1.234 81.037
sngl_burst 1000 0.580 1.554 643.501
sngl_ringdown 1 0.130 1.140 0.877
sngl_ringdown 10 0.050 0.133 74.974
sngl_ringdown 100 0.390 1.140 87.719
sngl_ringdown 1000 0.540 1.704 586.854
gds_trigger 1 0.060 0.423 2.362
gds_trigger 10 0.050 0.557 17.957
gds_trigger 100 0.110 0.244 410.177
gds_trigger 1000 0.620 2.659 376.081
sngl_unmodeled 1 0.040 0.735 1.360
sngl_unmodeled 10 0.050 0.335 29.856
sngl_unmodeled 100 0.090 1.100 90.909
sngl_unmodeled 1000 0.570 1.544 647.668
sngl_dperiodic 1 0.040 1.071 0.934
sngl_dperiodic 10 0.050 0.657 15.226
sngl_dperiodic 100 0.330 0.290 345.367
sngl_dperiodic 1000 0.660 1.577 634.115
multi_inspiral 1 0.060 0.453 2.205
multi_inspiral 10 0.080 0.459 21.791
multi_inspiral 100 0.190 1.184 84.459
multi_inspiral 1000 0.670 1.596 626.566
multi_burst 1 0.050 1.070 0.935
multi_burst 10 0.050 1.053 9.497
multi_burst 100 0.090 0.351 284.671
multi_burst 1000 0.550 1.517 659.196
frameset_loc 1 0.000 0.392 2.554
frameset_loc 10 0.030 0.112 89.591
frameset_loc 100 0.030 1.044 95.785
frameset_loc 1000 0.160 1.087 919.963
summ_value 1 0.160 1.088 0.919
summ_value 10 0.040 0.243 41.074
summ_value 100 0.050 1.051 95.147
summ_value 1000 0.210 1.105 904.977
summ_statistics 1 0.030 1.066 0.938
summ_statistics 10 0.120 1.086 9.208
summ_statistics 100 0.060 0.695 143.828
summ_statistics 1000 0.230 1.103 906.618
summ_spectrum 1 0.110 1.142 0.876
summ_spectrum 10 0.040 1.047 9.551
summ_spectrum 100 0.270 1.541 64.893
summ_spectrum 1000 0.380 5.208 192.012
summ_comment 1 0.050 1.116 0.896
summ_comment 10 0.140 1.136 8.803
summ_comment 100 0.100 0.573 174.452
summ_comment 1000 0.590 1.533 652.316
summ_csd 1 0.120 1.144 0.874
summ_csd 10 0.030 0.691 14.463
summ_csd 100 0.530 0.693 144.229
summ_csd 1000 0.310 5.190 192.678
summ_mime 1 0.120 1.148 0.871
summ_mime 10 0.040 0.411 24.311
summ_mime 100 0.100 1.480 67.568
summ_mime 1000 2.180 4.793 208.638
sngl_unmodeled_v 1 0.090 1.141 0.876
sngl_unmodeled_v 10 0.040 0.351 28.486
sngl_unmodeled_v 100 0.040 1.045 95.694
sngl_unmodeled_v 1000 0.150 0.721 1387.912
coinc_sngl 1 0.210 1.155 0.866
coinc_sngl 10 0.090 0.730 13.694
coinc_sngl 100 0.170 1.158 86.356
coinc_sngl 1000 1.170 2.908 343.879
search_summvars 1 0.030 0.453 2.207
search_summvars 10 0.800 1.783 5.609
search_summvars 100 0.030 0.331 302.030
search_summvars 1000 0.190 1.417 705.716
sngl_transdata 1 0.050 1.063 0.941
sngl_transdata 10 0.220 1.048 9.542
sngl_transdata 100 0.070 1.060 94.340
sngl_transdata 1000 0.420 4.345 230.150
sngl_mime 1 0.050 0.630 1.588
sngl_mime 10 0.050 0.634 15.777
sngl_mime 100 0.100 1.102 90.744
sngl_mime 1000 0.770 4.772 209.556
sngl_datasource 1 0.040 0.430 2.327
sngl_datasource 10 0.040 0.694 14.412
sngl_datasource 100 0.060 0.552 181.197
sngl_datasource 1000 0.180 1.096 912.409

Summary: