ldas-dev Database dev_1 Insertion Rates
Test Period January 17 2003 17:02:21
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.9 Generic_112233-03 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 2901M free, 1086M swap in use, 19G swap free
LDAS software ldas-0.5.65, 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.030 0.034 29.660
process 10 0.040 1.060 9.434
process 100 0.140 1.186 84.317
process 1000 0.980 2.023 494.315
runlist 1 0.010 0.196 5.109
runlist 10 0.020 0.192 51.967
runlist 100 0.030 1.029 97.182
runlist 1000 0.080 1.055 947.867
calib_info 1 0.020 1.039 0.962
calib_info 10 0.010 1.033 9.681
calib_info 100 0.040 1.049 95.329
calib_info 1000 2.060 3.760 265.957
sim_type 1 0.010 1.025 0.976
sim_type 10 0.010 1.027 9.737
sim_type 100 0.010 1.030 97.087
sim_type 1000 2.720 3.683 271.518
process_params 1 0.060 0.056 17.930
process_params 10 0.040 1.072 9.328
process_params 100 0.060 1.075 93.023
process_params 1000 0.140 1.119 893.655
frameset_chanlist 1 0.070 0.080 12.544
frameset_chanlist 10 0.070 1.094 9.141
frameset_chanlist 100 0.150 1.168 85.616
frameset_chanlist 1000 0.900 1.947 513.611
frameset_writer 1 0.050 0.070 14.193
frameset_writer 10 0.070 1.080 9.259
frameset_writer 100 0.060 1.082 92.421
frameset_writer 1000 0.200 1.131 884.173
segment_definer 1 0.050 0.073 13.618
segment_definer 10 0.060 1.079 9.268
segment_definer 100 0.060 1.078 92.764
segment_definer 1000 0.140 1.119 893.655
filter 1 0.070 0.081 12.337
filter 10 0.060 1.094 9.141
filter 100 0.150 1.173 85.251
filter 1000 0.930 1.980 505.051
search_summary 1 0.070 0.065 15.341
search_summary 10 0.070 1.069 9.355
search_summary 100 0.070 1.098 91.075
search_summary 1000 0.230 1.165 858.369
sim_inst 1 0.050 0.079 12.596
sim_inst 10 0.070 1.074 9.311
sim_inst 100 0.120 1.150 86.957
sim_inst 1000 0.880 1.932 517.598
sim_type_params 1 0.030 0.029 34.583
sim_type_params 10 0.010 1.022 9.785
sim_type_params 100 0.010 1.022 97.847
sim_type_params 1000 0.060 1.184 844.595
frameset 1 0.070 0.087 11.445
frameset 10 0.060 1.075 9.302
frameset 100 0.080 0.195 513.126
frameset 1000 0.180 1.140 877.193
segment 1 0.060 0.071 14.021
segment 10 0.070 1.067 9.372
segment 100 0.070 1.070 93.458
segment 1000 0.180 1.102 907.441
filter_params 1 0.070 0.080 12.495
filter_params 10 0.060 1.073 9.320
filter_params 100 0.080 1.080 92.593
filter_params 1000 0.150 1.136 880.282
gds_trigger 1 0.080 1.141 0.876
gds_trigger 10 0.090 1.092 9.158
gds_trigger 100 0.160 1.173 85.251
gds_trigger 1000 1.040 2.048 488.281
sngl_inspiral 1 0.100 1.125 0.889
sngl_inspiral 10 0.100 1.109 9.017
sngl_inspiral 100 0.190 1.190 84.034
sngl_inspiral 1000 1.170 3.104 322.165
sngl_burst 1 0.080 0.098 10.207
sngl_burst 10 0.080 1.091 9.166
sngl_burst 100 0.180 1.178 84.890
sngl_burst 1000 1.010 2.028 493.097
sngl_ringdown 1 0.080 0.100 10.047
sngl_ringdown 10 0.080 1.091 9.166
sngl_ringdown 100 0.180 1.186 84.317
sngl_ringdown 1000 1.000 2.016 496.032
sngl_unmodeled 1 0.080 0.098 10.240
sngl_unmodeled 10 0.090 1.094 9.141
sngl_unmodeled 100 0.170 1.192 83.893
sngl_unmodeled 1000 0.960 2.000 500.000
sngl_dperiodic 1 0.090 1.119 0.894
sngl_dperiodic 10 0.110 1.127 8.873
sngl_dperiodic 100 0.180 1.208 82.781
sngl_dperiodic 1000 1.050 2.054 486.855
multi_inspiral 1 0.090 0.121 8.239
multi_inspiral 10 0.100 1.107 9.033
multi_inspiral 100 0.210 1.210 82.645
multi_inspiral 1000 1.110 2.059 485.673
multi_burst 1 0.090 0.099 10.051
multi_burst 10 0.080 1.094 9.141
multi_burst 100 0.160 1.193 83.822
multi_burst 1000 0.990 1.987 503.271
exttrig_search 1 0.080 0.101 9.859
exttrig_search 10 0.100 0.211 47.290
exttrig_search 100 0.170 1.192 83.893
exttrig_search 1000 1.080 2.035 491.400
sim_inst_params 1 0.070 0.067 15.025
sim_inst_params 10 0.060 1.066 9.381
sim_inst_params 100 0.040 1.074 93.110
sim_inst_params 1000 0.100 1.099 909.918
waveburst 1 0.100 0.127 7.869
waveburst 10 0.100 1.111 9.001
waveburst 100 0.200 1.228 81.433
waveburst 1000 1.180 2.137 467.946
frameset_loc 1 0.020 0.032 31.555
frameset_loc 10 0.020 1.027 9.737
frameset_loc 100 0.020 1.042 95.969
frameset_loc 1000 0.130 1.089 918.274
summ_value 1 0.060 0.088 11.414
summ_value 10 0.070 1.065 9.390
summ_value 100 0.070 1.102 90.744
summ_value 1000 0.220 1.167 856.898
summ_statistics 1 0.070 1.099 0.910
summ_statistics 10 0.070 1.077 9.285
summ_statistics 100 0.080 1.111 90.009
summ_statistics 1000 0.280 1.191 839.631
summ_spectrum 1 0.060 0.184 5.422
summ_spectrum 10 0.060 1.068 9.363
summ_spectrum 100 0.090 1.107 90.334
summ_spectrum 1000 0.320 4.243 235.682
summ_comment 1 0.070 0.094 10.684
summ_comment 10 0.080 1.086 9.208
summ_comment 100 0.150 1.187 84.246
summ_comment 1000 0.990 2.014 496.524
summ_csd 1 0.070 1.096 0.912
summ_csd 10 0.070 1.077 9.285
summ_csd 100 0.100 1.106 90.416
summ_csd 1000 0.380 4.290 233.100
summ_mime 1 0.080 1.107 0.903
summ_mime 10 0.080 1.089 9.183
summ_mime 100 0.190 1.200 83.333
summ_mime 1000 2.840 4.967 201.329
sngl_unmodeled_v 1 0.050 0.098 10.219
sngl_unmodeled_v 10 0.070 1.068 9.363
sngl_unmodeled_v 100 0.070 1.082 92.421
sngl_unmodeled_v 1000 0.120 1.122 891.266
coinc_sngl 1 0.130 1.219 0.820
coinc_sngl 10 0.150 1.157 8.643
coinc_sngl 100 0.360 1.388 72.046
coinc_sngl 1000 3.020 3.973 251.699
search_summvars 1 0.050 0.067 14.925
search_summvars 10 0.040 1.073 9.320
search_summvars 100 0.040 0.184 542.202
search_summvars 1000 0.120 1.096 912.409
waveburst_mime 1 0.070 1.085 0.922
waveburst_mime 10 0.060 1.071 9.337
waveburst_mime 100 0.090 1.099 90.992
waveburst_mime 1000 0.520 5.298 188.750
sngl_transdata 1 0.080 1.097 0.912
sngl_transdata 10 0.080 1.096 9.124
sngl_transdata 100 0.110 1.115 89.686
sngl_transdata 1000 0.420 3.283 304.599
sngl_mime 1 0.080 1.097 0.912
sngl_mime 10 0.120 1.114 8.977
sngl_mime 100 0.180 1.202 83.195
sngl_mime 1000 1.180 5.138 194.628
sngl_datasource 1 0.070 0.081 12.277
sngl_datasource 10 0.070 1.069 9.355
sngl_datasource 100 0.070 1.095 91.324
sngl_datasource 1000 0.200 1.163 859.845

Summary: