ldas-wa Database lho_test Insertion Rates
| Test Period | January 16 2001 18:38:39 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS metaserver 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-4 Memory: 4096M real, 3557M free, 190M swap in use, 3189M swap free |
|
| LDAS software | ldas-0.0.13, 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.030 | 0.066 | 15.149 | process | 10 | 0.070 | 0.122 | 82.244 | process | 100 | 0.380 | 0.747 | 133.821 | process | 1000 | 3.460 | 6.526 | 153.233 | process_params | 1 | 0.050 | 0.137 | 7.286 | process_params | 10 | 0.050 | 0.101 | 98.563 | process_params | 100 | 0.270 | 0.467 | 214.136 | process_params | 1000 | 2.440 | 3.131 | 319.387 | frameset_chanlist | 1 | 0.040 | 0.074 | 13.466 | frameset_chanlist | 10 | 0.040 | 0.112 | 89.419 | frameset_chanlist | 100 | 0.140 | 0.320 | 312.474 | frameset_chanlist | 1000 | 1.200 | 2.003 | 499.251 | frameset_writer | 1 | 0.030 | 0.070 | 14.345 | frameset_writer | 10 | 0.050 | 0.081 | 123.192 | frameset_writer | 100 | 0.310 | 0.602 | 166.109 | frameset_writer | 1000 | 2.930 | 5.654 | 176.866 | segment_definer | 1 | 0.030 | 0.066 | 15.208 | segment_definer | 10 | 0.060 | 0.104 | 96.473 | segment_definer | 100 | 0.250 | 0.465 | 214.922 | segment_definer | 1000 | 2.300 | 4.796 | 208.507 | filter | 1 | 0.010 | 0.066 | 15.200 | filter | 10 | 0.050 | 0.117 | 85.286 | filter | 100 | 0.190 | 0.461 | 217.018 | filter | 1000 | 1.630 | 3.916 | 255.363 | frameset | 1 | 0.050 | 0.121 | 8.255 | frameset | 10 | 0.080 | 0.148 | 67.758 | frameset | 100 | 0.240 | 0.389 | 257.216 | frameset | 1000 | 2.020 | 3.189 | 313.578 | segment | 1 | 0.030 | 0.062 | 16.185 | segment | 10 | 0.040 | 0.063 | 159.875 | segment | 100 | 0.130 | 0.238 | 420.057 | segment | 1000 | 1.070 | 2.098 | 476.644 | filter_params | 1 | 0.030 | 0.075 | 13.390 | filter_params | 10 | 0.040 | 0.102 | 97.750 | filter_params | 100 | 0.260 | 0.408 | 244.902 | filter_params | 1000 | 2.460 | 3.255 | 307.220 | gds_trigger | 1 | 0.030 | 0.101 | 9.867 | gds_trigger | 10 | 0.070 | 0.206 | 48.548 | gds_trigger | 100 | 0.340 | 1.115 | 89.686 | gds_trigger | 1000 | 3.350 | 12.779 | 78.253 | sngl_inspiral | 1 | 0.050 | 0.086 | 11.687 | sngl_inspiral | 10 | 0.060 | 0.151 | 66.230 | sngl_inspiral | 100 | 0.240 | 0.430 | 232.390 | sngl_inspiral | 1000 | 2.130 | 3.941 | 253.743 | sngl_burst | 1 | 0.030 | 0.077 | 13.022 | sngl_burst | 10 | 0.040 | 0.082 | 121.923 | sngl_burst | 100 | 0.190 | 0.406 | 246.488 | sngl_burst | 1000 | 1.700 | 3.611 | 276.932 | sngl_ringdown | 1 | 0.040 | 0.084 | 11.858 | sngl_ringdown | 10 | 0.050 | 0.105 | 95.537 | sngl_ringdown | 100 | 0.200 | 0.388 | 257.969 | sngl_ringdown | 1000 | 1.710 | 3.876 | 257.998 | sngl_unmodeled | 1 | 0.040 | 0.100 | 10.048 | sngl_unmodeled | 10 | 0.070 | 0.140 | 71.658 | sngl_unmodeled | 100 | 0.310 | 0.559 | 178.777 | sngl_unmodeled | 1000 | 2.730 | 4.850 | 206.186 | sngl_dperiodic | 1 | 0.040 | 0.086 | 11.665 | sngl_dperiodic | 10 | 0.050 | 0.164 | 60.925 | sngl_dperiodic | 100 | 0.270 | 0.529 | 188.976 | sngl_dperiodic | 1000 | 2.240 | 4.440 | 225.225 | multi_inspiral | 1 | 0.030 | 0.083 | 12.103 | multi_inspiral | 10 | 0.050 | 0.090 | 111.307 | multi_inspiral | 100 | 0.220 | 0.437 | 228.592 | multi_inspiral | 1000 | 1.760 | 3.811 | 262.398 | multi_burst | 1 | 0.030 | 0.074 | 13.546 | multi_burst | 10 | 0.060 | 0.113 | 88.637 | multi_burst | 100 | 0.200 | 0.437 | 228.614 | multi_burst | 1000 | 1.720 | 3.595 | 278.164 | frameset_loc | 1 | 0.050 | 0.103 | 9.720 | frameset_loc | 10 | 0.060 | 0.151 | 66.138 | frameset_loc | 100 | 0.320 | 0.590 | 169.509 | frameset_loc | 1000 | 3.020 | 4.813 | 207.771 | summ_value | 1 | 0.050 | 0.087 | 11.499 | summ_value | 10 | 0.070 | 0.144 | 69.517 | summ_value | 100 | 0.370 | 0.621 | 161.115 | summ_value | 1000 | 3.280 | 5.592 | 178.827 | summ_statistics | 1 | 0.040 | 0.088 | 11.410 | summ_statistics | 10 | 0.060 | 0.141 | 70.755 | summ_statistics | 100 | 0.290 | 0.623 | 160.539 | summ_statistics | 1000 | 2.670 | 6.066 | 164.853 | summ_spectrum | 1 | 0.040 | 0.136 | 7.361 | summ_spectrum | 10 | 0.070 | 0.411 | 24.310 | summ_spectrum | 100 | 0.500 | 4.701 | 21.272 | summ_spectrum | 1000 | 4.330 | 42.725 | 23.406 | summ_comment | 1 | 0.040 | 0.096 | 10.460 | summ_comment | 10 | 0.090 | 0.123 | 80.997 | summ_comment | 100 | 0.450 | 0.606 | 164.987 | summ_comment | 1000 | 4.130 | 5.515 | 181.324 | sngl_transdata | 1 | 0.020 | 0.428 | 2.336 | sngl_transdata | 10 | 0.070 | 0.390 | 25.667 | sngl_transdata | 100 | 0.500 | 4.477 | 22.336 | sngl_transdata | 1000 | 4.640 | 40.073 | 24.954 | sngl_unmodeled_v | 1 | 0.020 | 0.065 | 15.371 | sngl_unmodeled_v | 10 | 0.040 | 0.115 | 87.116 | sngl_unmodeled_v | 100 | 0.170 | 0.350 | 285.412 | sngl_unmodeled_v | 1000 | 1.510 | 3.139 | 318.573 | coinc_sngl | 1 | 0.060 | 0.132 | 7.572 | coinc_sngl | 10 | 0.080 | 0.199 | 50.246 | coinc_sngl | 100 | 0.470 | 1.009 | 99.108 | coinc_sngl | 1000 | 4.320 | 10.178 | 98.251 | sngl_datasource | 1 | 0.040 | 0.098 | 10.222 | sngl_datasource | 10 | 0.050 | 0.077 | 129.114 | sngl_datasource | 100 | 0.290 | 0.414 | 241.407 | sngl_datasource | 1000 | 2.530 | 3.200 | 312.500 |
|---|
Summary: