ldas-dev Database cit_test Insertion Rates
Test Period June 13 2001 17:43:38
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, 3257M free, 257M swap in use, 3081M 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.018 54.401
process 10 0.000 0.023 430.775
process 100 0.040 0.070 1428.469
process 1000 0.270 0.584 1711.239
runlist 1 0.010 0.013 77.411
runlist 10 0.010 0.013 768.049
runlist 100 0.010 0.031 3267.974
runlist 1000 0.070 0.207 4819.440
process_params 1 0.030 0.030 33.469
process_params 10 0.020 0.033 300.120
process_params 100 0.030 0.058 1738.375
process_params 1000 0.100 0.320 3120.222
frameset_chanlist 1 0.030 0.033 29.853
frameset_chanlist 10 0.030 0.039 255.846
frameset_chanlist 100 0.030 0.077 1304.240
frameset_chanlist 1000 0.180 0.417 2400.050
frameset_writer 1 0.020 0.031 32.512
frameset_writer 10 0.030 0.035 282.103
frameset_writer 100 0.040 0.075 1326.260
frameset_writer 1000 0.110 0.485 2061.048
segment_definer 1 0.030 0.030 33.099
segment_definer 10 0.030 0.036 278.652
segment_definer 100 0.030 0.073 1372.213
segment_definer 1000 0.100 0.483 2069.297
filter 1 0.030 0.035 28.721
filter 10 0.040 0.041 242.512
filter 100 0.050 0.081 1232.787
filter 1000 0.200 0.567 1762.680
frameset 1 0.030 0.034 29.366
frameset 10 0.030 0.038 263.026
frameset 100 0.040 0.077 1294.716
frameset 1000 0.120 0.479 2088.511
segment 1 0.020 0.031 32.623
segment 10 0.020 0.039 256.069
segment 100 0.030 0.076 1320.237
segment 1000 0.080 0.457 2187.810
filter_params 1 0.020 0.030 33.254
filter_params 10 0.020 0.037 273.905
filter_params 100 0.040 0.071 1414.467
filter_params 1000 0.120 0.433 2310.835
gds_trigger 1 0.040 0.043 23.363
gds_trigger 10 0.040 0.050 199.892
gds_trigger 100 0.050 0.131 766.166
gds_trigger 1000 0.290 1.017 983.284
sngl_inspiral 1 0.040 0.043 23.438
sngl_inspiral 10 0.040 0.051 194.795
sngl_inspiral 100 0.050 0.148 676.320
sngl_inspiral 1000 0.330 1.344 744.048
sngl_burst 1 0.030 0.034 29.155
sngl_burst 10 0.030 0.042 240.923
sngl_burst 100 0.040 0.089 1117.356
sngl_burst 1000 0.240 0.724 1381.223
sngl_ringdown 1 0.030 0.035 28.640
sngl_ringdown 10 0.030 0.043 230.054
sngl_ringdown 100 0.040 0.095 1052.100
sngl_ringdown 1000 0.230 0.649 1540.457
sngl_unmodeled 1 0.030 0.035 28.329
sngl_unmodeled 10 0.030 0.040 250.721
sngl_unmodeled 100 0.050 0.117 857.523
sngl_unmodeled 1000 0.230 0.897 1114.553
sngl_dperiodic 1 0.030 0.037 26.742
sngl_dperiodic 10 0.040 0.046 218.727
sngl_dperiodic 100 0.050 0.101 985.911
sngl_dperiodic 1000 0.270 0.816 1226.057
multi_inspiral 1 0.040 0.043 23.391
multi_inspiral 10 0.040 0.052 191.446
multi_inspiral 100 0.060 0.136 734.883
multi_inspiral 1000 0.330 1.166 857.633
multi_burst 1 0.030 0.040 25.030
multi_burst 10 0.040 0.047 210.793
multi_burst 100 0.060 0.098 1020.856
multi_burst 1000 0.250 0.658 1519.424
frameset_loc 1 0.010 0.036 27.721
frameset_loc 10 0.010 0.016 640.123
frameset_loc 100 0.020 0.056 1796.558
frameset_loc 1000 0.110 0.481 2080.572
summ_value 1 0.030 0.053 18.875
summ_value 10 0.030 0.043 232.493
summ_value 100 0.050 0.091 1096.071
summ_value 1000 0.160 0.633 1578.943
summ_statistics 1 0.030 0.060 16.609
summ_statistics 10 0.040 0.047 214.648
summ_statistics 100 0.050 0.098 1017.501
summ_statistics 1000 0.180 0.684 1461.258
summ_spectrum 1 0.030 0.058 17.152
summ_spectrum 10 0.030 0.066 150.473
summ_spectrum 100 0.060 0.383 261.430
summ_spectrum 1000 0.240 3.031 329.924
summ_comment 1 0.030 0.057 17.648
summ_comment 10 0.040 0.047 214.966
summ_comment 100 0.050 0.107 936.373
summ_comment 1000 0.250 0.835 1197.763
summ_csd 1 0.030 0.057 17.477
summ_csd 10 0.040 0.061 163.808
summ_csd 100 0.050 0.362 276.575
summ_csd 1000 0.250 3.061 326.691
summ_mime 1 0.010 0.050 20.099
summ_mime 10 0.020 0.053 189.494
summ_mime 100 0.050 0.361 276.933
summ_mime 1000 0.530 3.379 295.946
sngl_transdata 1 0.010 0.035 28.739
sngl_transdata 10 0.010 0.043 233.405
sngl_transdata 100 0.040 0.318 314.337
sngl_transdata 1000 0.290 2.740 364.964
sngl_unmodeled_v 1 0.020 0.045 22.055
sngl_unmodeled_v 10 0.020 0.035 289.176
sngl_unmodeled_v 100 0.040 0.072 1395.089
sngl_unmodeled_v 1000 0.100 0.412 2427.173
sngl_mime 1 0.030 0.052 19.149
sngl_mime 10 0.040 0.058 172.079
sngl_mime 100 0.070 0.352 284.098
sngl_mime 1000 0.420 3.075 325.203
coinc_sngl 1 0.040 0.097 10.303
coinc_sngl 10 0.040 0.055 181.422
coinc_sngl 100 0.100 0.201 498.427
coinc_sngl 1000 0.580 1.771 564.653
sngl_datasource 1 0.030 0.045 22.307
sngl_datasource 10 0.030 0.040 250.840
sngl_datasource 100 0.040 0.074 1350.020
sngl_datasource 1000 0.150 0.472 2118.339

Summary: