ldas-cit Database cit_test Insertion Rates
Test Period July 30 2002 15:20:37
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-13 sun4u sparc SUNW,Sun-Fire-880
Memory: 8192M real, 6404M free, 992M swap in use, 5717M swap free
LDAS software ldas-0.3.41, 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.350 1.032 0.969
process 10 0.120 0.131 76.371
process 100 0.150 1.492 67.024
process 1000 0.180 1.279 781.861
runlist 1 0.220 1.113 0.898
runlist 10 0.020 0.588 17.018
runlist 100 0.010 0.262 381.681
runlist 1000 0.040 1.271 786.782
calib_info 1 0.000 0.631 1.584
calib_info 10 0.010 0.606 16.504
calib_info 100 0.020 2.547 39.262
calib_info 1000 0.190 15.454 64.708
process_params 1 0.140 0.141 7.072
process_params 10 0.160 0.813 12.304
process_params 100 0.020 1.046 95.602
process_params 1000 0.070 1.044 957.854
frameset_chanlist 1 0.440 1.867 0.536
frameset_chanlist 10 0.010 0.387 25.837
frameset_chanlist 100 0.320 0.930 107.489
frameset_chanlist 1000 0.150 0.625 1599.437
frameset_writer 1 0.020 0.445 2.247
frameset_writer 10 0.140 0.718 13.922
frameset_writer 100 0.030 0.317 315.193
frameset_writer 1000 0.070 2.220 450.450
segment_definer 1 0.020 0.813 1.230
segment_definer 10 0.250 0.695 14.392
segment_definer 100 0.030 0.445 224.903
segment_definer 1000 0.360 3.248 307.882
filter 1 0.020 1.039 0.962
filter 10 0.020 0.563 17.753
filter 100 0.040 0.336 297.787
filter 1000 0.440 1.181 846.740
search_summary 1 0.030 0.637 1.570
search_summary 10 0.020 0.325 30.753
search_summary 100 0.030 0.616 162.390
search_summary 1000 0.090 2.353 424.989
frameset 1 0.220 1.334 0.750
frameset 10 0.030 0.172 58.046
frameset 100 0.150 0.157 634.941
frameset 1000 0.080 1.353 739.098
segment 1 0.000 0.689 1.452
segment 10 0.020 0.597 16.758
segment 100 0.020 1.028 97.276
segment 1000 0.040 1.709 585.138
filter_params 1 0.030 0.803 1.245
filter_params 10 0.020 0.454 22.029
filter_params 100 0.040 1.034 96.712
filter_params 1000 0.070 1.051 951.475
gds_trigger 1 0.020 1.047 0.955
gds_trigger 10 0.030 0.376 26.588
gds_trigger 100 0.290 1.225 81.633
gds_trigger 1000 0.210 3.377 296.121
sngl_inspiral 1 0.080 0.259 3.860
sngl_inspiral 10 0.080 0.118 84.557
sngl_inspiral 100 0.050 0.719 139.161
sngl_inspiral 1000 1.540 5.358 186.637
sngl_burst 1 0.020 0.511 1.958
sngl_burst 10 0.010 0.138 72.434
sngl_burst 100 0.040 0.415 240.934
sngl_burst 1000 0.580 1.404 712.251
sngl_ringdown 1 0.030 1.048 0.954
sngl_ringdown 10 0.020 1.036 9.653
sngl_ringdown 100 0.040 0.340 293.959
sngl_ringdown 1000 1.270 2.961 337.724
sngl_unmodeled 1 0.020 0.351 2.846
sngl_unmodeled 10 0.020 0.358 27.904
sngl_unmodeled 100 0.030 1.140 87.719
sngl_unmodeled 1000 0.200 2.425 412.371
sngl_dperiodic 1 0.150 0.173 5.770
sngl_dperiodic 10 0.070 0.423 23.628
sngl_dperiodic 100 0.060 1.053 94.967
sngl_dperiodic 1000 1.540 5.079 196.889
multi_inspiral 1 0.050 0.695 1.439
multi_inspiral 10 0.010 0.761 13.138
multi_inspiral 100 0.040 0.815 122.666
multi_inspiral 1000 0.680 2.552 391.850
multi_burst 1 0.060 0.585 1.709
multi_burst 10 0.200 0.487 20.533
multi_burst 100 0.040 0.517 193.322
multi_burst 1000 0.560 2.542 393.391
exttrig_search 1 0.020 0.511 1.957
exttrig_search 10 0.010 0.610 16.383
exttrig_search 100 0.460 1.051 95.147
exttrig_search 1000 0.210 1.313 761.615
frameset_loc 1 0.030 0.158 6.341
frameset_loc 10 0.310 1.909 5.238
frameset_loc 100 0.010 0.436 229.155
frameset_loc 1000 0.070 1.032 968.992
summ_value 1 0.010 0.698 1.432
summ_value 10 0.290 1.272 7.862
summ_value 100 0.030 1.028 97.276
summ_value 1000 0.090 1.285 778.210
summ_statistics 1 0.020 0.820 1.219
summ_statistics 10 0.090 0.291 34.373
summ_statistics 100 0.030 0.816 122.483
summ_statistics 1000 0.100 1.367 731.529
summ_spectrum 1 0.130 0.492 2.034
summ_spectrum 10 0.020 1.031 9.699
summ_spectrum 100 0.030 2.379 42.034
summ_spectrum 1000 1.340 19.124 52.290
summ_comment 1 0.030 0.818 1.223
summ_comment 10 0.030 0.515 19.430
summ_comment 100 0.040 1.047 95.511
summ_comment 1000 2.100 18.107 55.227
summ_csd 1 0.020 0.243 4.114
summ_csd 10 0.230 1.062 9.416
summ_csd 100 0.510 2.546 39.277
summ_csd 1000 1.530 23.940 41.771
summ_mime 1 0.140 0.229 4.375
summ_mime 10 0.210 0.240 41.731
summ_mime 100 0.450 2.844 35.162
summ_mime 1000 1.060 21.400 46.729
sngl_unmodeled_v 1 0.010 0.498 2.007
sngl_unmodeled_v 10 0.020 0.585 17.080
sngl_unmodeled_v 100 0.040 0.135 739.836
sngl_unmodeled_v 1000 0.500 2.293 436.110
coinc_sngl 1 0.170 0.579 1.728
coinc_sngl 10 0.040 0.560 17.863
coinc_sngl 100 0.080 0.538 185.923
coinc_sngl 1000 1.240 2.276 439.367
search_summvars 1 0.010 0.067 14.962
search_summvars 10 0.230 1.339 7.468
search_summvars 100 0.020 0.338 295.551
search_summvars 1000 2.450 2.747 364.033
sngl_transdata 1 0.020 0.261 3.832
sngl_transdata 10 0.030 1.133 8.826
sngl_transdata 100 0.380 2.677 37.355
sngl_transdata 1000 2.210 18.108 55.224
sngl_mime 1 0.020 0.357 2.797
sngl_mime 10 0.020 1.030 9.709
sngl_mime 100 0.530 2.587 38.655
sngl_mime 1000 2.060 31.130 32.123
sngl_datasource 1 0.030 0.271 3.687
sngl_datasource 10 0.140 0.160 62.308
sngl_datasource 100 0.010 0.182 550.176
sngl_datasource 1000 0.600 2.440 409.836

Summary: