ldas-wa Database lho_test Insertion Rates
Test Period July 18 2001 12:29:05
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, 3188M free, 235M swap in use, 3097M swap free
LDAS software ldas-0.0.19, 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.026 38.951
process 10 0.000 0.026 381.010
process 100 0.040 0.081 1239.234
process 1000 0.320 0.748 1336.239
runlist 1 0.010 0.011 95.220
runlist 10 0.000 0.014 690.131
runlist 100 0.010 0.034 2985.075
runlist 1000 0.070 0.223 4476.236
process_params 1 0.030 0.042 23.881
process_params 10 0.010 0.017 575.639
process_params 100 0.020 0.046 2172.355
process_params 1000 0.070 0.318 3146.643
frameset_chanlist 1 0.040 0.047 21.457
frameset_chanlist 10 0.020 0.028 360.205
frameset_chanlist 100 0.020 0.075 1335.952
frameset_chanlist 1000 0.170 0.438 2284.952
frameset_writer 1 0.010 0.056 17.850
frameset_writer 10 0.010 0.026 388.395
frameset_writer 100 0.020 0.063 1582.053
frameset_writer 1000 0.100 0.485 2062.796
segment_definer 1 0.010 0.026 38.218
segment_definer 10 0.010 0.020 505.817
segment_definer 100 0.000 0.061 1643.115
segment_definer 1000 0.090 0.453 2207.540
filter 1 0.010 0.032 31.740
filter 10 0.020 0.025 397.883
filter 100 0.040 0.068 1478.590
filter 1000 0.210 0.532 1880.000
frameset 1 0.040 0.049 20.316
frameset 10 0.010 0.022 447.427
frameset 100 0.030 0.060 1657.990
frameset 1000 0.110 0.474 2109.104
segment 1 0.010 0.027 37.434
segment 10 0.010 0.020 499.500
segment 100 0.010 0.056 1800.374
segment 1000 0.070 0.493 2026.548
filter_params 1 0.010 0.029 33.989
filter_params 10 0.010 0.020 488.019
filter_params 100 0.020 0.066 1523.368
filter_params 1000 0.100 0.422 2371.382
gds_trigger 1 0.020 0.045 22.205
gds_trigger 10 0.020 0.039 255.363
gds_trigger 100 0.050 0.114 877.532
gds_trigger 1000 0.280 0.973 1028.219
sngl_inspiral 1 0.030 0.054 18.476
sngl_inspiral 10 0.030 0.040 247.415
sngl_inspiral 100 0.060 0.126 793.537
sngl_inspiral 1000 0.270 1.064 939.850
sngl_burst 1 0.030 0.042 24.044
sngl_burst 10 0.020 0.031 322.945
sngl_burst 100 0.050 0.097 1028.003
sngl_burst 1000 0.180 0.625 1598.918
sngl_ringdown 1 0.030 0.042 23.957
sngl_ringdown 10 0.020 0.032 315.866
sngl_ringdown 100 0.040 0.088 1137.346
sngl_ringdown 1000 0.200 0.638 1566.738
sngl_unmodeled 1 0.010 0.041 24.519
sngl_unmodeled 10 0.020 0.033 299.688
sngl_unmodeled 100 0.030 0.096 1047.022
sngl_unmodeled 1000 0.240 0.877 1140.412
sngl_dperiodic 1 0.020 0.045 22.254
sngl_dperiodic 10 0.030 0.035 288.725
sngl_dperiodic 100 0.050 0.098 1024.895
sngl_dperiodic 1000 0.260 0.735 1360.478
multi_inspiral 1 0.010 0.054 18.579
multi_inspiral 10 0.030 0.048 209.319
multi_inspiral 100 0.040 0.138 723.427
multi_inspiral 1000 0.280 1.084 922.509
multi_burst 1 0.020 0.042 23.549
multi_burst 10 0.030 0.031 319.775
multi_burst 100 0.040 0.080 1245.190
multi_burst 1000 0.190 0.652 1532.962
frameset_loc 1 0.010 0.022 44.795
frameset_loc 10 0.010 0.016 619.694
frameset_loc 100 0.020 0.055 1802.094
frameset_loc 1000 0.110 0.477 2097.175
summ_value 1 0.030 0.055 18.036
summ_value 10 0.020 0.027 370.425
summ_value 100 0.020 0.079 1269.084
summ_value 1000 0.150 0.621 1609.192
summ_statistics 1 0.010 0.047 21.409
summ_statistics 10 0.020 0.033 307.182
summ_statistics 100 0.040 0.100 1001.332
summ_statistics 1000 0.170 0.664 1504.907
summ_spectrum 1 0.020 0.047 21.406
summ_spectrum 10 0.020 0.045 220.692
summ_spectrum 100 0.040 0.352 283.965
summ_spectrum 1000 0.250 3.071 325.627
summ_comment 1 0.020 0.046 21.928
summ_comment 10 0.020 0.033 303.361
summ_comment 100 0.040 0.156 641.997
summ_comment 1000 0.210 0.841 1188.562
summ_csd 1 0.020 0.046 21.561
summ_csd 10 0.020 0.046 215.559
summ_csd 100 0.040 0.350 285.668
summ_csd 1000 0.270 3.072 325.521
summ_mime 1 0.020 0.048 20.974
summ_mime 10 0.010 0.050 200.566
summ_mime 100 0.050 0.365 273.901
summ_mime 1000 0.470 3.308 302.297
sngl_transdata 1 0.010 0.036 27.451
sngl_transdata 10 0.020 0.046 217.647
sngl_transdata 100 0.040 0.321 311.180
sngl_transdata 1000 0.300 2.844 351.617
sngl_unmodeled_v 1 0.030 0.047 21.101
sngl_unmodeled_v 10 0.030 0.038 263.873
sngl_unmodeled_v 100 0.030 0.068 1472.646
sngl_unmodeled_v 1000 0.100 0.425 2353.606
sngl_mime 1 0.030 0.045 22.090
sngl_mime 10 0.020 0.050 200.900
sngl_mime 100 0.050 0.348 287.462
sngl_mime 1000 0.430 3.065 326.264
coinc_sngl 1 0.030 0.110 9.085
coinc_sngl 10 0.040 0.059 169.188
coinc_sngl 100 0.100 0.224 446.514
coinc_sngl 1000 0.670 2.001 499.750
sngl_datasource 1 0.010 0.030 33.115
sngl_datasource 10 0.010 0.022 445.137
sngl_datasource 100 0.030 0.072 1395.849
sngl_datasource 1000 0.130 0.450 2224.001

Summary: