ldas-wa Database lho_test Insertion Rates
| Test Period | March 07 2001 13:02:51 | |
|---|---|---|
| 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, 3461M free, 187M swap in use, 3153M swap free |
|
| LDAS software | ldas-0.0.15, 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.079 | 12.725 | process | 10 | 0.070 | 0.120 | 83.608 | process | 100 | 0.360 | 0.507 | 197.077 | process | 1000 | 3.380 | 4.597 | 217.533 | process_params | 1 | 0.040 | 0.101 | 9.942 | process_params | 10 | 0.050 | 0.100 | 100.274 | process_params | 100 | 0.270 | 0.342 | 292.181 | process_params | 1000 | 2.410 | 3.153 | 317.158 | frameset_chanlist | 1 | 0.040 | 0.068 | 14.602 | frameset_chanlist | 10 | 0.030 | 0.120 | 83.633 | frameset_chanlist | 100 | 0.130 | 0.329 | 303.959 | frameset_chanlist | 1000 | 1.130 | 1.845 | 542.005 | frameset_writer | 1 | 0.010 | 0.063 | 15.910 | frameset_writer | 10 | 0.050 | 0.134 | 74.587 | frameset_writer | 100 | 0.310 | 0.534 | 187.111 | frameset_writer | 1000 | 2.880 | 5.474 | 182.682 | segment_definer | 1 | 0.020 | 0.060 | 16.563 | segment_definer | 10 | 0.050 | 0.128 | 78.359 | segment_definer | 100 | 0.290 | 0.518 | 192.989 | segment_definer | 1000 | 2.250 | 4.567 | 218.962 | filter | 1 | 0.030 | 0.077 | 13.023 | filter | 10 | 0.030 | 0.072 | 138.074 | filter | 100 | 0.180 | 0.372 | 269.065 | filter | 1000 | 1.570 | 3.181 | 314.367 | frameset | 1 | 0.030 | 0.098 | 10.158 | frameset | 10 | 0.060 | 0.123 | 81.037 | frameset | 100 | 0.220 | 0.394 | 254.079 | frameset | 1000 | 1.990 | 3.275 | 305.344 | segment | 1 | 0.020 | 0.062 | 16.030 | segment | 10 | 0.040 | 0.063 | 159.734 | segment | 100 | 0.110 | 0.272 | 367.068 | segment | 1000 | 1.030 | 1.778 | 562.430 | filter_params | 1 | 0.020 | 0.060 | 16.741 | filter_params | 10 | 0.050 | 0.096 | 103.669 | filter_params | 100 | 0.270 | 0.400 | 250.164 | filter_params | 1000 | 2.420 | 3.359 | 297.708 | gds_trigger | 1 | 0.060 | 0.084 | 11.960 | gds_trigger | 10 | 0.070 | 0.166 | 60.392 | gds_trigger | 100 | 0.340 | 0.660 | 151.542 | gds_trigger | 1000 | 3.210 | 12.127 | 82.461 | sngl_inspiral | 1 | 0.030 | 0.083 | 12.022 | sngl_inspiral | 10 | 0.070 | 0.129 | 77.560 | sngl_inspiral | 100 | 0.230 | 0.723 | 138.236 | sngl_inspiral | 1000 | 2.060 | 4.409 | 226.809 | sngl_burst | 1 | 0.020 | 0.076 | 13.245 | sngl_burst | 10 | 0.060 | 0.080 | 125.240 | sngl_burst | 100 | 0.190 | 0.388 | 258.033 | sngl_burst | 1000 | 1.650 | 3.545 | 282.087 | sngl_ringdown | 1 | 0.030 | 0.124 | 8.094 | sngl_ringdown | 10 | 0.050 | 0.143 | 70.100 | sngl_ringdown | 100 | 0.200 | 0.402 | 248.940 | sngl_ringdown | 1000 | 1.630 | 3.978 | 251.383 | sngl_unmodeled | 1 | 0.020 | 0.078 | 12.817 | sngl_unmodeled | 10 | 0.070 | 0.145 | 69.163 | sngl_unmodeled | 100 | 0.290 | 0.530 | 188.723 | sngl_unmodeled | 1000 | 2.630 | 5.025 | 199.005 | sngl_dperiodic | 1 | 0.050 | 0.090 | 11.146 | sngl_dperiodic | 10 | 0.070 | 0.135 | 73.854 | sngl_dperiodic | 100 | 0.260 | 0.504 | 198.449 | sngl_dperiodic | 1000 | 2.150 | 4.683 | 213.538 | multi_inspiral | 1 | 0.060 | 0.085 | 11.811 | multi_inspiral | 10 | 0.060 | 0.086 | 116.303 | multi_inspiral | 100 | 0.210 | 0.483 | 206.997 | multi_inspiral | 1000 | 1.700 | 4.035 | 247.831 | multi_burst | 1 | 0.030 | 0.078 | 12.826 | multi_burst | 10 | 0.050 | 0.105 | 95.418 | multi_burst | 100 | 0.240 | 0.480 | 208.311 | multi_burst | 1000 | 1.650 | 3.884 | 257.467 | frameset_loc | 1 | 0.030 | 0.100 | 10.026 | frameset_loc | 10 | 0.060 | 0.096 | 103.748 | frameset_loc | 100 | 0.320 | 0.544 | 183.939 | frameset_loc | 1000 | 2.940 | 4.778 | 209.293 | summ_value | 1 | 0.050 | 0.091 | 10.972 | summ_value | 10 | 0.060 | 0.161 | 61.920 | summ_value | 100 | 0.350 | 0.678 | 147.399 | summ_value | 1000 | 3.210 | 5.659 | 176.710 | summ_statistics | 1 | 0.050 | 0.081 | 12.322 | summ_statistics | 10 | 0.060 | 0.136 | 73.319 | summ_statistics | 100 | 0.300 | 0.619 | 161.595 | summ_statistics | 1000 | 2.580 | 5.759 | 173.641 | summ_spectrum | 1 | 0.030 | 0.109 | 9.134 | summ_spectrum | 10 | 0.060 | 0.431 | 23.206 | summ_spectrum | 100 | 0.450 | 4.572 | 21.872 | summ_spectrum | 1000 | 4.150 | 42.355 | 23.610 | summ_comment | 1 | 0.040 | 0.079 | 12.713 | summ_comment | 10 | 0.080 | 0.149 | 67.070 | summ_comment | 100 | 0.420 | 0.607 | 164.757 | summ_comment | 1000 | 4.120 | 5.341 | 187.231 | summ_csd | 1 | 0.040 | 0.121 | 8.260 | summ_csd | 10 | 0.070 | 0.414 | 24.171 | summ_csd | 100 | 0.510 | 4.569 | 21.887 | summ_csd | 1000 | 4.390 | 42.349 | 23.613 | sngl_transdata | 1 | 0.020 | 0.086 | 11.656 | sngl_transdata | 10 | 0.060 | 0.378 | 26.451 | sngl_transdata | 100 | 0.490 | 4.330 | 23.095 | sngl_transdata | 1000 | 4.630 | 40.146 | 24.909 | sngl_unmodeled_v | 1 | 0.030 | 0.084 | 11.842 | sngl_unmodeled_v | 10 | 0.040 | 0.131 | 76.554 | sngl_unmodeled_v | 100 | 0.170 | 0.351 | 285.151 | sngl_unmodeled_v | 1000 | 1.500 | 3.211 | 311.429 | coinc_sngl | 1 | 0.050 | 0.126 | 7.912 | coinc_sngl | 10 | 0.090 | 0.207 | 48.395 | coinc_sngl | 100 | 0.450 | 0.998 | 100.189 | coinc_sngl | 1000 | 4.220 | 10.179 | 98.241 | sngl_datasource | 1 | 0.030 | 0.079 | 12.630 | sngl_datasource | 10 | 0.050 | 0.128 | 77.965 | sngl_datasource | 100 | 0.270 | 0.372 | 268.545 | sngl_datasource | 1000 | 2.480 | 3.172 | 315.259 |
|---|
Summary: