ldas-wa Database lho_test Insertion Rates
Test Period June 13 2001 19:04:57
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, 3419M free, 198M swap in use, 3165M 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.010 0.019 52.529
process 10 0.020 0.025 394.353
process 100 0.030 0.062 1611.344
process 1000 0.290 0.702 1423.609
runlist 1 0.000 0.011 93.458
runlist 10 0.010 0.014 705.667
runlist 100 0.020 0.033 3075.220
runlist 1000 0.060 0.223 4490.184
process_params 1 0.030 0.040 25.255
process_params 10 0.020 0.032 310.965
process_params 100 0.040 0.065 1539.670
process_params 1000 0.100 0.330 3032.122
frameset_chanlist 1 0.020 0.045 22.054
frameset_chanlist 10 0.020 0.041 241.115
frameset_chanlist 100 0.050 0.093 1075.789
frameset_chanlist 1000 0.180 0.477 2095.219
frameset_writer 1 0.020 0.043 23.015
frameset_writer 10 0.030 0.037 268.687
frameset_writer 100 0.040 0.078 1278.478
frameset_writer 1000 0.110 0.487 2052.196
segment_definer 1 0.030 0.040 24.794
segment_definer 10 0.030 0.036 280.725
segment_definer 100 0.050 0.083 1199.616
segment_definer 1000 0.100 0.472 2118.783
filter 1 0.030 0.045 22.158
filter 10 0.030 0.040 247.359
filter 100 0.040 0.080 1256.266
filter 1000 0.210 0.594 1684.307
frameset 1 0.020 0.049 20.504
frameset 10 0.030 0.036 275.976
frameset 100 0.040 0.075 1335.845
frameset 1000 0.140 0.550 1818.856
segment 1 0.030 0.041 24.152
segment 10 0.020 0.034 294.750
segment 100 0.030 0.073 1360.692
segment 1000 0.080 0.505 1980.649
filter_params 1 0.030 0.043 23.104
filter_params 10 0.030 0.037 272.948
filter_params 100 0.030 0.080 1255.619
filter_params 1000 0.120 0.453 2206.439
gds_trigger 1 0.040 0.063 15.937
gds_trigger 10 0.040 0.054 183.759
gds_trigger 100 0.050 0.125 801.892
gds_trigger 1000 0.260 0.967 1034.551
sngl_inspiral 1 0.040 0.061 16.372
sngl_inspiral 10 0.040 0.050 199.752
sngl_inspiral 100 0.070 0.133 749.839
sngl_inspiral 1000 0.270 1.050 952.381
sngl_burst 1 0.030 0.048 20.793
sngl_burst 10 0.030 0.046 217.988
sngl_burst 100 0.040 0.096 1037.237
sngl_burst 1000 0.190 0.702 1423.751
sngl_ringdown 1 0.030 0.050 19.933
sngl_ringdown 10 0.040 0.042 236.412
sngl_ringdown 100 0.040 0.097 1027.781
sngl_ringdown 1000 0.220 0.703 1422.354
sngl_unmodeled 1 0.030 0.049 20.450
sngl_unmodeled 10 0.030 0.043 235.222
sngl_unmodeled 100 0.040 0.105 951.402
sngl_unmodeled 1000 0.240 0.864 1157.561
sngl_dperiodic 1 0.030 0.053 18.842
sngl_dperiodic 10 0.040 0.045 223.404
sngl_dperiodic 100 0.050 0.109 920.293
sngl_dperiodic 1000 0.240 0.753 1327.417
multi_inspiral 1 0.030 0.062 16.148
multi_inspiral 10 0.040 0.051 195.446
multi_inspiral 100 0.070 0.135 741.191
multi_inspiral 1000 0.280 1.110 900.901
multi_burst 1 0.030 0.057 17.475
multi_burst 10 0.040 0.046 216.563
multi_burst 100 0.050 0.105 955.146
multi_burst 1000 0.240 0.662 1511.645
frameset_loc 1 0.010 0.022 45.554
frameset_loc 10 0.020 0.017 593.542
frameset_loc 100 0.020 0.054 1858.736
frameset_loc 1000 0.100 0.471 2121.602
summ_value 1 0.030 0.054 18.568
summ_value 10 0.030 0.043 235.250
summ_value 100 0.050 0.100 1000.200
summ_value 1000 0.160 0.633 1579.457
summ_statistics 1 0.030 0.060 16.623
summ_statistics 10 0.030 0.047 210.988
summ_statistics 100 0.050 0.098 1024.947
summ_statistics 1000 0.180 0.687 1454.924
summ_spectrum 1 0.030 0.058 17.218
summ_spectrum 10 0.030 0.057 175.673
summ_spectrum 100 0.060 0.352 283.749
summ_spectrum 1000 0.250 3.025 330.579
summ_comment 1 0.030 0.056 17.736
summ_comment 10 0.030 0.046 217.103
summ_comment 100 0.050 0.104 960.809
summ_comment 1000 0.250 0.789 1268.205
summ_csd 1 0.030 0.057 17.583
summ_csd 10 0.030 0.060 167.062
summ_csd 100 0.050 0.359 278.177
summ_csd 1000 0.260 3.168 315.657
summ_mime 1 0.020 0.046 21.899
summ_mime 10 0.010 0.050 201.361
summ_mime 100 0.050 0.365 273.790
summ_mime 1000 0.540 3.372 296.560
sngl_transdata 1 0.000 0.034 29.452
sngl_transdata 10 0.010 0.041 241.774
sngl_transdata 100 0.050 0.319 313.755
sngl_transdata 1000 0.300 2.774 360.490
sngl_unmodeled_v 1 0.030 0.048 20.986
sngl_unmodeled_v 10 0.020 0.037 270.168
sngl_unmodeled_v 100 0.030 0.073 1379.044
sngl_unmodeled_v 1000 0.100 0.427 2341.679
sngl_mime 1 0.030 0.050 19.998
sngl_mime 10 0.030 0.060 166.731
sngl_mime 100 0.070 0.354 282.375
sngl_mime 1000 0.390 3.031 329.924
coinc_sngl 1 0.030 0.104 9.591
coinc_sngl 10 0.040 0.058 173.874
coinc_sngl 100 0.070 0.214 467.996
coinc_sngl 1000 0.650 1.962 509.684
sngl_datasource 1 0.030 0.048 21.022
sngl_datasource 10 0.030 0.039 254.680
sngl_datasource 100 0.040 0.074 1355.454
sngl_datasource 1000 0.140 0.455 2198.546

Summary: