ldas-wa Database lho_test Insertion Rates
| Test Period | April 09 2001 14:42:20 | |
|---|---|---|
| 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, 3616M free, 72M swap in use, 3301M 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.050 | 0.100 | 10.002 | process | 10 | 0.070 | 0.118 | 84.553 | process | 100 | 0.350 | 0.566 | 176.730 | process | 1000 | 3.410 | 4.883 | 204.792 | process_params | 1 | 0.060 | 0.117 | 8.538 | process_params | 10 | 0.080 | 0.127 | 78.908 | process_params | 100 | 0.300 | 0.443 | 225.786 | process_params | 1000 | 2.460 | 3.182 | 314.268 | frameset_chanlist | 1 | 0.060 | 0.098 | 10.235 | frameset_chanlist | 10 | 0.070 | 0.104 | 96.219 | frameset_chanlist | 100 | 0.160 | 0.342 | 292.060 | frameset_chanlist | 1000 | 1.170 | 1.870 | 534.759 | frameset_writer | 1 | 0.060 | 0.128 | 7.794 | frameset_writer | 10 | 0.090 | 0.138 | 72.331 | frameset_writer | 100 | 0.350 | 0.628 | 159.234 | frameset_writer | 1000 | 3.010 | 5.221 | 191.534 | segment_definer | 1 | 0.060 | 0.121 | 8.278 | segment_definer | 10 | 0.070 | 0.151 | 66.040 | segment_definer | 100 | 0.270 | 0.495 | 201.844 | segment_definer | 1000 | 2.350 | 4.480 | 223.214 | filter | 1 | 0.060 | 0.096 | 10.424 | filter | 10 | 0.070 | 0.148 | 67.477 | filter | 100 | 0.200 | 0.402 | 248.691 | filter | 1000 | 1.620 | 3.170 | 315.457 | frameset | 1 | 0.070 | 0.143 | 7.017 | frameset | 10 | 0.070 | 0.161 | 62.044 | frameset | 100 | 0.260 | 0.421 | 237.308 | frameset | 1000 | 2.060 | 3.128 | 319.693 | segment | 1 | 0.050 | 0.101 | 9.909 | segment | 10 | 0.060 | 0.092 | 108.661 | segment | 100 | 0.150 | 0.309 | 323.869 | segment | 1000 | 1.060 | 2.032 | 492.126 | filter_params | 1 | 0.060 | 0.102 | 9.768 | filter_params | 10 | 0.080 | 0.128 | 77.849 | filter_params | 100 | 0.300 | 0.424 | 235.955 | filter_params | 1000 | 2.470 | 3.301 | 302.939 | gds_trigger | 1 | 0.070 | 0.119 | 8.403 | gds_trigger | 10 | 0.110 | 0.187 | 53.449 | gds_trigger | 100 | 0.370 | 0.778 | 128.617 | gds_trigger | 1000 | 3.300 | 12.230 | 81.766 | sngl_inspiral | 1 | 0.060 | 0.117 | 8.523 | sngl_inspiral | 10 | 0.070 | 0.111 | 90.265 | sngl_inspiral | 100 | 0.250 | 0.491 | 203.714 | sngl_inspiral | 1000 | 2.100 | 4.376 | 228.519 | sngl_burst | 1 | 0.050 | 0.108 | 9.282 | sngl_burst | 10 | 0.060 | 0.117 | 85.288 | sngl_burst | 100 | 0.190 | 0.395 | 253.347 | sngl_burst | 1000 | 1.680 | 3.533 | 283.046 | sngl_ringdown | 1 | 0.070 | 0.103 | 9.733 | sngl_ringdown | 10 | 0.090 | 0.152 | 65.737 | sngl_ringdown | 100 | 0.230 | 0.421 | 237.635 | sngl_ringdown | 1000 | 1.710 | 3.653 | 273.748 | sngl_unmodeled | 1 | 0.060 | 0.127 | 7.860 | sngl_unmodeled | 10 | 0.080 | 0.156 | 64.295 | sngl_unmodeled | 100 | 0.320 | 0.538 | 185.795 | sngl_unmodeled | 1000 | 2.690 | 4.811 | 207.857 | sngl_dperiodic | 1 | 0.060 | 0.166 | 6.030 | sngl_dperiodic | 10 | 0.080 | 0.101 | 99.261 | sngl_dperiodic | 100 | 0.270 | 0.475 | 210.615 | sngl_dperiodic | 1000 | 2.200 | 4.597 | 217.533 | multi_inspiral | 1 | 0.070 | 0.121 | 8.247 | multi_inspiral | 10 | 0.080 | 0.131 | 76.133 | multi_inspiral | 100 | 0.230 | 0.453 | 220.554 | multi_inspiral | 1000 | 1.750 | 3.989 | 250.689 | multi_burst | 1 | 0.080 | 0.107 | 9.312 | multi_burst | 10 | 0.080 | 0.154 | 64.808 | multi_burst | 100 | 0.240 | 0.462 | 216.570 | multi_burst | 1000 | 1.750 | 3.821 | 261.712 | frameset_loc | 1 | 0.040 | 0.167 | 5.972 | frameset_loc | 10 | 0.060 | 0.130 | 77.011 | frameset_loc | 100 | 0.320 | 0.613 | 163.210 | frameset_loc | 1000 | 3.030 | 4.780 | 209.205 | summ_value | 1 | 0.050 | 0.102 | 9.851 | summ_value | 10 | 0.080 | 0.151 | 66.422 | summ_value | 100 | 0.380 | 0.583 | 171.550 | summ_value | 1000 | 3.300 | 5.653 | 176.897 | summ_statistics | 1 | 0.060 | 0.113 | 8.835 | summ_statistics | 10 | 0.090 | 0.173 | 57.693 | summ_statistics | 100 | 0.330 | 0.633 | 157.975 | summ_statistics | 1000 | 2.680 | 5.673 | 176.274 | summ_spectrum | 1 | 0.060 | 0.204 | 4.900 | summ_spectrum | 10 | 0.080 | 0.453 | 22.074 | summ_spectrum | 100 | 0.500 | 4.701 | 21.272 | summ_spectrum | 1000 | 4.170 | 41.176 | 24.286 | summ_comment | 1 | 0.080 | 0.134 | 7.468 | summ_comment | 10 | 0.120 | 0.180 | 55.428 | summ_comment | 100 | 0.460 | 0.600 | 166.668 | summ_comment | 1000 | 4.100 | 5.110 | 195.695 | summ_csd | 1 | 0.070 | 0.159 | 6.295 | summ_csd | 10 | 0.100 | 0.422 | 23.715 | summ_csd | 100 | 0.530 | 4.821 | 20.743 | summ_csd | 1000 | 4.470 | 43.939 | 22.759 | sngl_transdata | 1 | 0.040 | 0.127 | 7.849 | sngl_transdata | 10 | 0.080 | 0.430 | 23.280 | sngl_transdata | 100 | 0.560 | 4.575 | 21.858 | sngl_transdata | 1000 | 4.630 | 39.598 | 25.254 | sngl_unmodeled_v | 1 | 0.040 | 0.106 | 9.428 | sngl_unmodeled_v | 10 | 0.060 | 0.081 | 123.245 | sngl_unmodeled_v | 100 | 0.190 | 0.353 | 283.075 | sngl_unmodeled_v | 1000 | 1.530 | 3.322 | 301.023 | coinc_sngl | 1 | 0.050 | 0.161 | 6.204 | coinc_sngl | 10 | 0.100 | 0.194 | 51.618 | coinc_sngl | 100 | 0.490 | 0.981 | 101.967 | coinc_sngl | 1000 | 4.290 | 10.464 | 95.566 | sngl_datasource | 1 | 0.040 | 0.099 | 10.087 | sngl_datasource | 10 | 0.090 | 0.110 | 90.631 | sngl_datasource | 100 | 0.320 | 0.410 | 244.183 | sngl_datasource | 1000 | 2.590 | 3.329 | 300.391 |
|---|
Summary: