ldas-wa Database lho_test Insertion Rates
Test Period June 08 2001 11:04:18
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3493M free, 197M swap in use, 3169M swap free
LDAS software ldas-0.0.18, 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.000 0.018 54.939
process 10 0.010 0.025 394.742
process 100 0.040 0.086 1160.308
process 1000 0.260 0.742 1348.230
runlist 1 0.000 0.010 101.031
runlist 10 0.000 0.014 718.907
runlist 100 0.010 0.032 3123.048
runlist 1000 0.070 0.265 3776.877
process_params 1 0.030 0.029 33.910
process_params 10 0.030 0.031 317.622
process_params 100 0.030 0.068 1472.190
process_params 1000 0.100 0.414 2416.702
frameset_chanlist 1 0.030 0.036 28.130
frameset_chanlist 10 0.030 0.037 269.368
frameset_chanlist 100 0.050 0.094 1058.817
frameset_chanlist 1000 0.160 0.506 1975.644
frameset_writer 1 0.030 0.030 33.803
frameset_writer 10 0.030 0.036 276.878
frameset_writer 100 0.040 0.078 1275.461
frameset_writer 1000 0.110 0.512 1953.262
segment_definer 1 0.020 0.030 33.124
segment_definer 10 0.020 0.035 286.467
segment_definer 100 0.040 0.082 1214.993
segment_definer 1000 0.110 0.505 1981.018
filter 1 0.040 0.037 26.977
filter 10 0.030 0.040 247.782
filter 100 0.040 0.083 1211.358
filter 1000 0.190 0.692 1444.803
frameset 1 0.030 0.033 30.052
frameset 10 0.030 0.039 258.699
frameset 100 0.040 0.084 1184.806
frameset 1000 0.120 0.590 1695.249
segment 1 0.020 0.029 34.472
segment 10 0.030 0.034 294.985
segment 100 0.030 0.085 1182.788
segment 1000 0.080 0.543 1841.556
filter_params 1 0.020 0.030 33.056
filter_params 10 0.030 0.036 277.346
filter_params 100 0.040 0.089 1129.854
filter_params 1000 0.130 0.614 1628.094
gds_trigger 1 0.040 0.043 23.259
gds_trigger 10 0.040 0.051 194.466
gds_trigger 100 0.060 0.116 865.014
gds_trigger 1000 0.280 1.017 983.284
sngl_inspiral 1 0.030 0.041 24.637
sngl_inspiral 10 0.040 0.050 201.483
sngl_inspiral 100 0.050 0.128 779.022
sngl_inspiral 1000 0.290 1.114 897.666
sngl_burst 1 0.030 0.034 29.125
sngl_burst 10 0.040 0.041 241.063
sngl_burst 100 0.050 0.090 1109.632
sngl_burst 1000 0.210 0.783 1276.645
sngl_ringdown 1 0.030 0.034 29.822
sngl_ringdown 10 0.040 0.041 243.043
sngl_ringdown 100 0.050 0.094 1063.321
sngl_ringdown 1000 0.210 0.775 1290.791
sngl_unmodeled 1 0.030 0.034 29.305
sngl_unmodeled 10 0.030 0.041 243.605
sngl_unmodeled 100 0.040 0.117 856.340
sngl_unmodeled 1000 0.200 0.946 1057.565
sngl_dperiodic 1 0.030 0.036 27.892
sngl_dperiodic 10 0.040 0.044 227.211
sngl_dperiodic 100 0.050 0.116 858.834
sngl_dperiodic 1000 0.230 0.921 1085.992
multi_inspiral 1 0.030 0.042 23.843
multi_inspiral 10 0.040 0.061 162.824
multi_inspiral 100 0.070 0.124 803.600
multi_inspiral 1000 0.330 1.147 871.840
multi_burst 1 0.040 0.042 23.613
multi_burst 10 0.030 0.046 218.003
multi_burst 100 0.060 0.107 933.724
multi_burst 1000 0.230 0.829 1206.641
frameset_loc 1 0.010 0.011 90.188
frameset_loc 10 0.010 0.016 621.852
frameset_loc 100 0.030 0.055 1813.204
frameset_loc 1000 0.110 0.495 2018.212
summ_value 1 0.030 0.035 28.876
summ_value 10 0.030 0.045 220.429
summ_value 100 0.050 0.107 936.067
summ_value 1000 0.170 0.887 1127.063
summ_statistics 1 0.040 0.040 25.056
summ_statistics 10 0.040 0.046 217.174
summ_statistics 100 0.050 0.111 899.321
summ_statistics 1000 0.180 0.930 1075.228
summ_spectrum 1 0.030 0.035 28.420
summ_spectrum 10 0.020 0.056 180.138
summ_spectrum 100 0.050 0.369 271.365
summ_spectrum 1000 0.260 3.138 318.674
summ_comment 1 0.030 0.040 24.797
summ_comment 10 0.040 0.045 220.391
summ_comment 100 0.050 0.108 923.293
summ_comment 1000 0.240 0.950 1053.148
summ_csd 1 0.030 0.036 27.715
summ_csd 10 0.030 0.058 173.409
summ_csd 100 0.050 0.379 263.506
summ_csd 1000 0.270 3.126 319.898
summ_mime 1 0.020 0.023 43.912
summ_mime 10 0.020 0.044 228.775
summ_mime 100 0.060 0.373 268.048
summ_mime 1000 0.450 3.560 280.899
sngl_transdata 1 0.020 0.035 28.959
sngl_transdata 10 0.020 0.041 245.513
sngl_transdata 100 0.040 0.327 305.637
sngl_transdata 1000 0.290 2.892 345.781
sngl_unmodeled_v 1 0.020 0.031 31.804
sngl_unmodeled_v 10 0.020 0.037 267.387
sngl_unmodeled_v 100 0.040 0.080 1251.173
sngl_unmodeled_v 1000 0.090 0.520 1923.876
sngl_mime 1 0.030 0.052 19.087
sngl_mime 10 0.030 0.059 168.073
sngl_mime 100 0.060 0.373 268.163
sngl_mime 1000 0.360 3.076 325.098
coinc_sngl 1 0.040 0.042 23.885
coinc_sngl 10 0.040 0.060 165.895
coinc_sngl 100 0.090 0.233 428.872
coinc_sngl 1000 0.610 2.178 459.137
sngl_datasource 1 0.030 0.047 21.455
sngl_datasource 10 0.030 0.039 255.480
sngl_datasource 100 0.040 0.077 1300.644
sngl_datasource 1000 0.160 0.554 1804.507

Summary: