ldas-dev Database cit_1 Insertion Rates
Test Period November 07 2002 16:47:24
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, 3197M free, 803M swap in use, 2354M swap free
LDAS software ldas-0.4.101, 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.060 0.186 5.388
process 10 0.890 1.043 9.588
process 100 0.050 1.083 92.336
process 1000 0.320 1.363 733.676
runlist 1 0.010 1.026 0.975
runlist 10 0.540 1.416 7.062
runlist 100 0.010 1.022 97.847
runlist 1000 0.070 1.043 958.773
calib_info 1 0.010 0.259 3.858
calib_info 10 0.010 1.024 9.766
calib_info 100 0.030 1.032 96.899
calib_info 1000 0.230 3.127 319.795
process_params 1 0.050 1.068 0.936
process_params 10 0.040 1.059 9.443
process_params 100 0.050 1.065 93.897
process_params 1000 0.240 1.083 923.361
frameset_chanlist 1 0.050 1.078 0.928
frameset_chanlist 10 0.970 1.496 6.684
frameset_chanlist 100 0.320 1.086 92.081
frameset_chanlist 1000 0.280 1.316 759.878
frameset_writer 1 0.960 1.163 0.860
frameset_writer 10 0.520 1.424 7.022
frameset_writer 100 0.070 0.150 666.010
frameset_writer 1000 0.130 1.094 914.077
segment_definer 1 0.400 0.476 2.101
segment_definer 10 0.070 0.236 42.409
segment_definer 100 0.220 1.063 94.073
segment_definer 1000 0.110 1.079 926.784
filter 1 0.070 1.086 0.921
filter 10 0.930 1.376 7.267
filter 100 0.090 0.187 535.361
filter 1000 0.290 1.314 761.035
search_summary 1 0.050 1.079 0.927
search_summary 10 0.420 0.415 24.104
search_summary 100 0.070 1.066 93.809
search_summary 1000 0.180 1.102 907.441
frameset 1 0.060 1.080 0.926
frameset 10 0.060 1.071 9.337
frameset 100 0.060 0.254 394.092
frameset 1000 0.160 1.097 911.577
segment 1 0.280 0.327 3.054
segment 10 0.050 1.058 9.452
segment 100 0.050 1.060 94.340
segment 1000 0.090 1.072 932.836
filter_params 1 0.070 0.220 4.544
filter_params 10 0.990 1.666 6.002
filter_params 100 0.060 0.220 455.413
filter_params 1000 0.120 1.092 915.751
gds_trigger 1 0.070 1.097 0.912
gds_trigger 10 0.570 1.454 6.878
gds_trigger 100 0.090 0.257 389.684
gds_trigger 1000 0.380 1.355 738.007
sngl_inspiral 1 0.090 1.113 0.898
sngl_inspiral 10 0.080 1.092 9.158
sngl_inspiral 100 1.130 1.679 59.559
sngl_inspiral 1000 0.430 1.366 732.064
sngl_burst 1 0.060 1.093 0.915
sngl_burst 10 0.080 1.087 9.200
sngl_burst 100 0.620 1.507 66.357
sngl_burst 1000 0.370 1.359 735.835
sngl_ringdown 1 0.060 0.253 3.957
sngl_ringdown 10 0.160 0.253 39.598
sngl_ringdown 100 1.110 1.586 63.052
sngl_ringdown 1000 0.340 1.339 746.826
sngl_unmodeled 1 0.140 0.175 5.713
sngl_unmodeled 10 0.090 0.220 45.474
sngl_unmodeled 100 0.580 1.484 67.385
sngl_unmodeled 1000 0.340 1.344 744.048
sngl_dperiodic 1 0.190 1.103 0.907
sngl_dperiodic 10 0.070 1.084 9.225
sngl_dperiodic 100 0.100 1.108 90.253
sngl_dperiodic 1000 0.400 1.370 729.927
multi_inspiral 1 0.090 1.119 0.894
multi_inspiral 10 0.080 1.088 9.191
multi_inspiral 100 0.100 1.113 89.847
multi_inspiral 1000 0.430 1.365 732.601
multi_burst 1 0.070 0.207 4.832
multi_burst 10 0.970 1.404 7.123
multi_burst 100 1.140 1.674 59.737
multi_burst 1000 0.340 1.335 749.064
exttrig_search 1 0.080 1.102 0.907
exttrig_search 10 0.540 1.442 6.935
exttrig_search 100 0.450 0.490 204.278
exttrig_search 1000 0.410 1.392 718.391
frameset_loc 1 0.010 1.034 0.967
frameset_loc 10 0.010 1.025 9.756
frameset_loc 100 1.060 1.532 65.274
frameset_loc 1000 0.100 1.055 947.867
summ_value 1 0.950 1.177 0.850
summ_value 10 0.070 1.070 9.346
summ_value 100 0.620 1.491 67.069
summ_value 1000 0.160 1.103 906.618
summ_statistics 1 0.630 1.465 0.683
summ_statistics 10 0.060 1.071 9.337
summ_statistics 100 0.090 1.078 92.764
summ_statistics 1000 0.300 1.104 905.797
summ_spectrum 1 0.050 0.223 4.487
summ_spectrum 10 0.070 1.072 9.328
summ_spectrum 100 0.080 1.260 79.365
summ_spectrum 1000 1.900 5.604 178.444
summ_comment 1 0.060 1.104 0.906
summ_comment 10 0.060 1.071 9.337
summ_comment 100 0.090 1.098 91.075
summ_comment 1000 0.540 1.458 685.871
summ_csd 1 0.060 1.093 0.915
summ_csd 10 0.980 1.395 7.168
summ_csd 100 0.090 1.079 92.678
summ_csd 1000 0.290 4.172 239.693
summ_mime 1 0.070 1.096 0.912
summ_mime 10 0.530 1.442 6.935
summ_mime 100 0.100 1.103 90.662
summ_mime 1000 1.570 4.166 240.038
sngl_unmodeled_v 1 0.050 0.234 4.269
sngl_unmodeled_v 10 0.070 1.067 9.372
sngl_unmodeled_v 100 0.060 1.065 93.897
sngl_unmodeled_v 1000 0.210 1.208 827.815
coinc_sngl 1 0.130 1.200 0.833
coinc_sngl 10 0.100 0.224 44.679
coinc_sngl 100 0.310 0.391 255.596
coinc_sngl 1000 2.540 2.825 353.982
search_summvars 1 0.060 1.066 0.938
search_summvars 10 0.050 1.059 9.443
search_summvars 100 0.060 0.143 700.001
search_summvars 1000 1.420 2.270 440.529
sngl_transdata 1 0.060 1.089 0.918
sngl_transdata 10 0.080 1.079 9.268
sngl_transdata 100 0.090 1.257 79.554
sngl_transdata 1000 0.340 4.251 235.239
sngl_mime 1 0.070 1.094 0.914
sngl_mime 10 0.060 1.080 9.259
sngl_mime 100 1.170 1.584 63.131
sngl_mime 1000 0.490 4.448 224.820
sngl_datasource 1 0.080 1.084 0.923
sngl_datasource 10 0.060 1.064 9.398
sngl_datasource 100 0.450 0.464 215.706
sngl_datasource 1000 0.150 1.100 909.091

Summary: