ldas-dev Database cit_1 Insertion Rates
Test Period June 05 2002 19:04:39
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, 2910M free, 1020M swap in use, 2257M swap free
LDAS software ldas-0.2.40, 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.710 1.314 0.761
process 10 0.020 0.093 107.437
process 100 0.080 0.304 329.323
process 1000 1.270 2.753 363.240
runlist 1 0.300 0.656 1.524
runlist 10 0.010 0.307 32.619
runlist 100 0.010 0.443 225.788
runlist 1000 0.980 1.525 655.738
calib_info 1 0.010 0.552 1.811
calib_info 10 0.010 0.662 15.108
calib_info 100 0.030 0.468 213.734
calib_info 1000 0.300 3.156 316.857
process_params 1 0.030 0.118 8.485
process_params 10 0.030 1.035 9.662
process_params 100 0.040 0.093 1075.384
process_params 1000 0.160 1.084 922.509
frameset_chanlist 1 0.320 1.671 0.598
frameset_chanlist 10 0.040 0.151 66.326
frameset_chanlist 100 0.080 1.086 92.081
frameset_chanlist 1000 0.470 1.498 667.557
frameset_writer 1 0.030 0.400 2.500
frameset_writer 10 0.030 0.226 44.301
frameset_writer 100 0.060 1.064 93.985
frameset_writer 1000 0.170 1.088 919.118
segment_definer 1 0.090 0.649 1.541
segment_definer 10 0.030 1.042 9.597
segment_definer 100 0.040 0.649 154.136
segment_definer 1000 0.140 1.079 926.784
filter 1 0.150 1.163 0.860
filter 10 0.040 0.233 42.831
filter 100 0.080 1.091 91.659
filter 1000 0.500 1.520 657.895
search_summary 1 0.150 0.812 1.232
search_summary 10 0.030 0.079 125.960
search_summary 100 0.050 0.441 226.901
search_summary 1000 0.190 1.098 910.747
frameset 1 0.350 0.395 2.535
frameset 10 0.060 1.040 9.615
frameset 100 0.050 0.189 529.608
frameset 1000 0.700 2.421 413.052
segment 1 0.340 0.377 2.652
segment 10 0.030 0.287 34.784
segment 100 0.050 1.044 95.785
segment 1000 0.700 1.064 939.850
filter_params 1 0.030 1.040 0.962
filter_params 10 0.040 0.375 26.649
filter_params 100 0.040 0.464 215.467
filter_params 1000 1.110 3.005 332.779
gds_trigger 1 0.170 0.441 2.266
gds_trigger 10 0.070 0.131 76.085
gds_trigger 100 0.110 1.100 90.909
gds_trigger 1000 0.610 1.560 641.026
sngl_inspiral 1 0.370 0.379 2.638
sngl_inspiral 10 0.060 0.205 48.786
sngl_inspiral 100 0.130 0.202 495.646
sngl_inspiral 1000 1.340 2.005 498.753
sngl_burst 1 0.400 0.725 1.378
sngl_burst 10 0.050 1.056 9.470
sngl_burst 100 0.100 0.470 212.791
sngl_burst 1000 0.570 1.543 648.088
sngl_ringdown 1 0.040 1.052 0.951
sngl_ringdown 10 0.050 1.057 9.461
sngl_ringdown 100 0.100 0.196 511.318
sngl_ringdown 1000 0.530 1.533 652.316
sngl_unmodeled 1 0.050 1.048 0.954
sngl_unmodeled 10 0.060 1.057 9.461
sngl_unmodeled 100 0.080 1.199 83.403
sngl_unmodeled 1000 0.560 2.545 392.927
sngl_dperiodic 1 0.040 1.062 0.942
sngl_dperiodic 10 0.040 0.438 22.809
sngl_dperiodic 100 0.110 1.122 89.127
sngl_dperiodic 1000 0.670 1.680 595.238
multi_inspiral 1 0.370 1.070 0.935
multi_inspiral 10 0.050 0.672 14.873
multi_inspiral 100 0.110 1.110 90.090
multi_inspiral 1000 0.670 2.613 382.702
multi_burst 1 0.130 0.159 6.296
multi_burst 10 0.040 1.052 9.506
multi_burst 100 0.100 1.093 91.491
multi_burst 1000 0.560 1.521 657.462
exttrig_search 1 0.050 0.093 10.754
exttrig_search 10 0.050 1.061 9.425
exttrig_search 100 0.100 0.226 443.129
exttrig_search 1000 0.610 1.542 648.508
frameset_loc 1 0.020 0.083 12.055
frameset_loc 10 0.020 1.022 9.785
frameset_loc 100 0.030 1.024 97.656
frameset_loc 1000 0.150 1.076 929.368
summ_value 1 0.030 0.232 4.310
summ_value 10 0.040 0.666 15.022
summ_value 100 0.050 0.371 269.904
summ_value 1000 0.220 1.107 903.342
summ_statistics 1 0.040 0.238 4.198
summ_statistics 10 0.040 1.044 9.579
summ_statistics 100 0.050 1.050 95.238
summ_statistics 1000 0.240 1.110 900.901
summ_spectrum 1 0.060 1.040 0.962
summ_spectrum 10 0.040 1.046 9.560
summ_spectrum 100 0.060 1.132 88.339
summ_spectrum 1000 0.340 5.701 175.408
summ_comment 1 0.050 0.112 8.903
summ_comment 10 0.050 1.054 9.488
summ_comment 100 0.100 0.234 427.756
summ_comment 1000 0.590 1.685 593.472
summ_csd 1 0.040 0.465 2.151
summ_csd 10 0.050 0.119 83.991
summ_csd 100 0.080 1.059 94.429
summ_csd 1000 0.340 4.189 238.720
summ_mime 1 0.040 0.108 9.284
summ_mime 10 0.050 0.143 69.719
summ_mime 100 0.100 1.107 90.334
summ_mime 1000 1.540 6.046 165.399
sngl_unmodeled_v 1 0.030 0.129 7.723
sngl_unmodeled_v 10 0.030 1.039 9.625
sngl_unmodeled_v 100 0.050 0.284 352.079
sngl_unmodeled_v 1000 1.120 2.061 485.201
coinc_sngl 1 0.070 1.082 0.924
coinc_sngl 10 0.090 1.119 8.937
coinc_sngl 100 0.320 1.251 79.936
coinc_sngl 1000 1.310 3.117 320.821
search_summvars 1 0.020 0.133 7.543
search_summvars 10 0.020 0.672 14.885
search_summvars 100 0.040 0.251 398.592
search_summvars 1000 0.110 1.057 946.074
sngl_transdata 1 0.040 0.258 3.871
sngl_transdata 10 0.040 1.051 9.515
sngl_transdata 100 0.070 1.179 84.818
sngl_transdata 1000 0.400 4.240 235.849
sngl_mime 1 0.040 1.053 0.950
sngl_mime 10 0.050 1.056 9.470
sngl_mime 100 0.120 0.484 206.721
sngl_mime 1000 1.630 5.443 183.722
sngl_datasource 1 0.030 0.668 1.498
sngl_datasource 10 0.030 0.191 52.399
sngl_datasource 100 0.050 0.469 213.140
sngl_datasource 1000 1.250 1.984 504.032

Summary: