ldas-dev Database cit_test Insertion Rates
Test Period July 18 2001 12:14:32
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, 3177M free, 206M swap in use, 11G 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.020 0.020 50.063
process 10 0.020 0.027 370.686
process 100 0.040 0.077 1302.151
process 1000 0.330 0.871 1148.617
runlist 1 0.010 0.010 96.200
runlist 10 0.010 0.015 683.714
runlist 100 0.010 0.034 2911.886
runlist 1000 0.070 0.216 4635.596
process_params 1 0.020 0.042 24.057
process_params 10 0.010 0.017 597.372
process_params 100 0.000 0.042 2363.005
process_params 1000 0.080 0.363 2755.588
frameset_chanlist 1 0.040 0.053 18.854
frameset_chanlist 10 0.020 0.025 403.551
frameset_chanlist 100 0.020 0.077 1302.490
frameset_chanlist 1000 0.150 0.420 2381.916
frameset_writer 1 0.020 0.026 37.995
frameset_writer 10 0.010 0.018 553.833
frameset_writer 100 0.020 0.068 1469.508
frameset_writer 1000 0.100 0.514 1945.722
segment_definer 1 0.010 0.026 38.045
segment_definer 10 0.010 0.020 493.097
segment_definer 100 0.020 0.059 1695.174
segment_definer 1000 0.090 0.490 2042.092
filter 1 0.010 0.031 32.331
filter 10 0.020 0.025 400.593
filter 100 0.030 0.065 1550.003
filter 1000 0.180 0.531 1884.517
frameset 1 0.030 0.049 20.318
frameset 10 0.010 0.022 450.552
frameset 100 0.020 0.055 1810.774
frameset 1000 0.110 0.426 2347.914
segment 1 0.020 0.028 36.114
segment 10 0.010 0.020 508.001
segment 100 0.020 0.058 1730.793
segment 1000 0.070 0.517 1934.427
filter_params 1 0.010 0.029 34.433
filter_params 10 0.010 0.026 384.615
filter_params 100 0.020 0.060 1665.862
filter_params 1000 0.100 0.481 2080.477
gds_trigger 1 0.020 0.044 22.675
gds_trigger 10 0.030 0.036 278.552
gds_trigger 100 0.040 0.118 847.070
gds_trigger 1000 0.280 0.977 1023.576
sngl_inspiral 1 0.020 0.052 19.337
sngl_inspiral 10 0.030 0.042 235.816
sngl_inspiral 100 0.040 0.142 705.154
sngl_inspiral 1000 0.310 1.231 812.348
sngl_burst 1 0.020 0.040 25.110
sngl_burst 10 0.020 0.030 330.055
sngl_burst 100 0.040 0.097 1029.378
sngl_burst 1000 0.190 0.667 1499.529
sngl_ringdown 1 0.020 0.041 24.579
sngl_ringdown 10 0.020 0.032 309.023
sngl_ringdown 100 0.040 0.088 1136.260
sngl_ringdown 1000 0.230 0.674 1484.221
sngl_unmodeled 1 0.020 0.040 25.244
sngl_unmodeled 10 0.030 0.033 305.913
sngl_unmodeled 100 0.030 0.103 966.660
sngl_unmodeled 1000 0.220 0.880 1135.896
sngl_dperiodic 1 0.030 0.047 21.199
sngl_dperiodic 10 0.020 0.034 292.184
sngl_dperiodic 100 0.040 0.101 990.786
sngl_dperiodic 1000 0.220 0.819 1221.687
multi_inspiral 1 0.020 0.054 18.642
multi_inspiral 10 0.030 0.037 269.186
multi_inspiral 100 0.060 0.133 752.162
multi_inspiral 1000 0.290 1.139 877.963
multi_burst 1 0.030 0.057 17.456
multi_burst 10 0.020 0.031 327.054
multi_burst 100 0.040 0.082 1219.036
multi_burst 1000 0.230 0.659 1517.974
frameset_loc 1 0.010 0.022 45.693
frameset_loc 10 0.000 0.016 642.096
frameset_loc 100 0.020 0.059 1687.678
frameset_loc 1000 0.130 0.518 1929.902
summ_value 1 0.020 0.039 25.900
summ_value 10 0.010 0.027 372.870
summ_value 100 0.030 0.079 1259.430
summ_value 1000 0.190 0.663 1507.611
summ_statistics 1 0.030 0.088 11.419
summ_statistics 10 0.020 0.032 315.398
summ_statistics 100 0.030 0.088 1140.628
summ_statistics 1000 0.180 0.690 1449.019
summ_spectrum 1 0.010 0.043 23.265
summ_spectrum 10 0.020 0.044 227.946
summ_spectrum 100 0.040 0.352 284.123
summ_spectrum 1000 0.260 3.213 311.236
summ_comment 1 0.020 0.044 22.633
summ_comment 10 0.020 0.032 307.778
summ_comment 100 0.030 0.092 1082.544
summ_comment 1000 0.220 0.837 1194.739
summ_csd 1 0.020 0.046 21.945
summ_csd 10 0.020 0.045 221.946
summ_csd 100 0.040 0.364 274.771
summ_csd 1000 0.270 3.192 313.283
summ_mime 1 0.020 0.046 21.557
summ_mime 10 0.020 0.048 207.646
summ_mime 100 0.060 0.371 269.737
summ_mime 1000 0.440 3.405 293.686
sngl_transdata 1 0.010 0.035 28.589
sngl_transdata 10 0.020 0.042 239.797
sngl_transdata 100 0.040 0.334 299.353
sngl_transdata 1000 0.320 2.846 351.370
sngl_unmodeled_v 1 0.030 0.045 22.031
sngl_unmodeled_v 10 0.030 0.037 268.039
sngl_unmodeled_v 100 0.030 0.070 1423.366
sngl_unmodeled_v 1000 0.100 0.425 2354.193
sngl_mime 1 0.020 0.041 24.211
sngl_mime 10 0.020 0.049 205.343
sngl_mime 100 0.060 0.354 282.539
sngl_mime 1000 0.390 3.107 321.854
coinc_sngl 1 0.030 0.095 10.527
coinc_sngl 10 0.030 0.058 172.441
coinc_sngl 100 0.090 0.210 475.364
coinc_sngl 1000 0.610 1.866 535.906
sngl_datasource 1 0.010 0.030 33.401
sngl_datasource 10 0.010 0.023 443.007
sngl_datasource 100 0.020 0.061 1641.174
sngl_datasource 1000 0.130 0.584 1712.229

Summary: