ldas-test Database cprod_t Insertion Rates
Test Period April 09 2001 13:38:00
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3117M free, 222M swap in use, 2977M swap free
LDAS software ldas-0.0.16, 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.040 0.078 12.779
process 10 0.070 0.118 84.647
process 100 0.360 0.475 210.309
process 1000 3.390 4.246 235.516
process_params 1 0.050 0.071 14.156
process_params 10 0.070 0.108 92.510
process_params 100 0.300 0.394 253.977
process_params 1000 2.430 2.860 349.650
frameset_chanlist 1 0.060 0.079 12.645
frameset_chanlist 10 0.070 0.095 104.723
frameset_chanlist 100 0.160 0.266 376.563
frameset_chanlist 1000 1.170 1.686 593.120
frameset_writer 1 0.060 0.078 12.794
frameset_writer 10 0.080 0.124 80.606
frameset_writer 100 0.350 0.552 181.238
frameset_writer 1000 2.930 4.154 240.732
segment_definer 1 0.050 0.078 12.900
segment_definer 10 0.080 0.121 82.383
segment_definer 100 0.270 0.407 245.619
segment_definer 1000 2.310 3.415 292.826
filter 1 0.060 0.089 11.274
filter 10 0.070 0.135 74.036
filter 100 0.210 0.328 305.019
filter 1000 1.590 2.525 396.040
frameset 1 0.060 0.085 11.754
frameset 10 0.080 0.115 86.879
frameset 100 0.260 0.350 285.484
frameset 1000 2.050 2.639 378.931
segment 1 0.050 0.101 9.917
segment 10 0.070 0.106 94.782
segment 100 0.150 0.262 381.445
segment 1000 1.070 1.527 654.879
filter_params 1 0.050 0.085 11.761
filter_params 10 0.060 0.104 96.561
filter_params 100 0.300 0.388 257.664
filter_params 1000 2.450 2.910 343.643
gds_trigger 1 0.080 0.099 10.062
gds_trigger 10 0.110 0.132 75.923
gds_trigger 100 0.370 0.567 176.350
gds_trigger 1000 3.330 7.739 129.216
sngl_inspiral 1 0.060 0.094 10.632
sngl_inspiral 10 0.080 0.139 72.091
sngl_inspiral 100 0.220 0.365 274.179
sngl_inspiral 1000 1.740 2.935 340.716
sngl_burst 1 0.040 0.083 11.991
sngl_burst 10 0.070 0.114 87.613
sngl_burst 100 0.230 0.376 265.983
sngl_burst 1000 1.700 2.857 350.018
sngl_ringdown 1 0.060 0.090 11.082
sngl_ringdown 10 0.070 0.103 96.654
sngl_ringdown 100 0.230 0.314 318.497
sngl_ringdown 1000 1.710 2.948 339.213
sngl_unmodeled 1 0.060 0.088 11.342
sngl_unmodeled 10 0.090 0.115 87.054
sngl_unmodeled 100 0.280 0.406 246.091
sngl_unmodeled 1000 2.170 3.467 288.434
sngl_dperiodic 1 0.060 0.098 10.229
sngl_dperiodic 10 0.080 0.127 78.647
sngl_dperiodic 100 0.280 0.418 239.148
sngl_dperiodic 1000 2.220 3.674 272.183
multi_inspiral 1 0.060 0.093 10.764
multi_inspiral 10 0.080 0.132 75.871
multi_inspiral 100 0.230 0.346 288.799
multi_inspiral 1000 1.750 3.177 314.762
multi_burst 1 0.070 0.094 10.636
multi_burst 10 0.070 0.103 97.038
multi_burst 100 0.240 0.368 271.973
multi_burst 1000 1.730 3.060 326.797
frameset_loc 1 0.040 0.084 11.948
frameset_loc 10 0.060 0.110 90.621
frameset_loc 100 0.330 0.443 225.560
frameset_loc 1000 2.980 3.942 253.678
summ_value 1 0.060 0.078 12.788
summ_value 10 0.070 0.126 79.336
summ_value 100 0.370 0.517 193.544
summ_value 1000 3.290 4.594 217.675
summ_statistics 1 0.070 0.097 10.340
summ_statistics 10 0.090 0.136 73.280
summ_statistics 100 0.330 0.579 172.585
summ_statistics 1000 2.660 4.395 227.531
summ_spectrum 1 0.060 0.102 9.793
summ_spectrum 10 0.100 0.243 41.145
summ_spectrum 100 0.490 2.202 45.413
summ_spectrum 1000 4.200 19.107 52.337
summ_comment 1 0.070 0.099 10.099
summ_comment 10 0.110 0.129 77.560
summ_comment 100 0.480 0.571 175.212
summ_comment 1000 4.080 4.680 213.675
summ_csd 1 0.060 0.108 9.231
summ_csd 10 0.100 0.323 30.924
summ_csd 100 0.530 2.312 43.253
summ_csd 1000 4.460 20.363 49.109
sngl_transdata 1 0.040 0.078 12.850
sngl_transdata 10 0.080 0.216 46.232
sngl_transdata 100 0.520 2.048 48.828
sngl_transdata 1000 4.590 19.073 52.430
sngl_unmodeled_v 1 0.040 0.072 13.800
sngl_unmodeled_v 10 0.050 0.084 119.569
sngl_unmodeled_v 100 0.190 0.288 347.386
sngl_unmodeled_v 1000 1.520 2.392 418.060
coinc_sngl 1 0.070 0.090 11.092
coinc_sngl 10 0.100 0.169 59.014
coinc_sngl 100 0.480 0.750 133.267
coinc_sngl 1000 4.250 7.513 133.103
sngl_datasource 1 0.040 0.058 17.300
sngl_datasource 10 0.090 0.105 95.047
sngl_datasource 100 0.310 0.377 265.590
sngl_datasource 1000 2.560 2.895 345.423

Summary: