ldas-dev Database ldas_tst Insertion Rates
| Test Period | November 07 2001 19:54:52 | |
|---|---|---|
| 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, 3112M free, 310M swap in use, 2949M swap free |
|
| LDAS software | ldas-0.0.22, 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.037 | 27.173 | process | 10 | 0.020 | 0.030 | 334.829 | process | 100 | 0.050 | 0.122 | 817.314 | process | 1000 | 0.350 | 0.815 | 1227.316 | runlist | 1 | 0.000 | 0.015 | 67.686 | runlist | 10 | 0.000 | 0.013 | 743.771 | runlist | 100 | 0.010 | 0.028 | 3591.438 | runlist | 1000 | 0.070 | 0.229 | 4362.488 | process_params | 1 | 0.030 | 0.026 | 38.322 | process_params | 10 | 0.020 | 0.031 | 317.571 | process_params | 100 | 0.030 | 0.056 | 1776.167 | process_params | 1000 | 0.110 | 0.413 | 2423.990 | frameset_chanlist | 1 | 0.020 | 0.047 | 21.371 | frameset_chanlist | 10 | 0.020 | 0.037 | 272.398 | frameset_chanlist | 100 | 0.020 | 0.079 | 1264.606 | frameset_chanlist | 1000 | 0.220 | 0.493 | 2029.867 | frameset_writer | 1 | 0.010 | 0.025 | 40.479 | frameset_writer | 10 | 0.000 | 0.017 | 590.598 | frameset_writer | 100 | 0.020 | 0.074 | 1358.530 | frameset_writer | 1000 | 0.100 | 0.595 | 1681.908 | segment_definer | 1 | 0.010 | 0.025 | 40.035 | segment_definer | 10 | 0.010 | 0.019 | 532.652 | segment_definer | 100 | 0.010 | 0.083 | 1209.965 | segment_definer | 1000 | 0.100 | 0.560 | 1784.898 | filter | 1 | 0.010 | 0.029 | 35.031 | filter | 10 | 0.010 | 0.023 | 427.332 | filter | 100 | 0.040 | 0.070 | 1419.708 | filter | 1000 | 0.240 | 0.572 | 1749.111 | frameset | 1 | 0.020 | 0.035 | 28.798 | frameset | 10 | 0.010 | 0.024 | 413.377 | frameset | 100 | 0.030 | 0.082 | 1215.185 | frameset | 1000 | 0.120 | 0.537 | 1863.457 | segment | 1 | 0.010 | 0.027 | 36.937 | segment | 10 | 0.010 | 0.019 | 535.647 | segment | 100 | 0.010 | 0.056 | 1786.640 | segment | 1000 | 0.060 | 0.522 | 1914.158 | filter_params | 1 | 0.020 | 0.050 | 19.849 | filter_params | 10 | 0.010 | 0.021 | 471.076 | filter_params | 100 | 0.020 | 0.056 | 1793.979 | filter_params | 1000 | 0.110 | 0.547 | 1829.080 | gds_trigger | 1 | 0.020 | 0.042 | 23.533 | gds_trigger | 10 | 0.020 | 0.033 | 306.288 | gds_trigger | 100 | 0.040 | 0.126 | 791.534 | gds_trigger | 1000 | 0.320 | 1.175 | 851.064 | sngl_inspiral | 1 | 0.020 | 0.050 | 20.075 | sngl_inspiral | 10 | 0.030 | 0.042 | 240.587 | sngl_inspiral | 100 | 0.060 | 0.131 | 762.759 | sngl_inspiral | 1000 | 0.330 | 1.219 | 820.345 | sngl_burst | 1 | 0.020 | 0.052 | 19.254 | sngl_burst | 10 | 0.020 | 0.030 | 336.632 | sngl_burst | 100 | 0.040 | 0.087 | 1148.132 | sngl_burst | 1000 | 0.300 | 0.823 | 1214.711 | sngl_ringdown | 1 | 0.010 | 0.038 | 26.357 | sngl_ringdown | 10 | 0.010 | 0.030 | 338.009 | sngl_ringdown | 100 | 0.040 | 0.089 | 1126.773 | sngl_ringdown | 1000 | 0.260 | 0.711 | 1406.767 | sngl_unmodeled | 1 | 0.010 | 0.056 | 17.784 | sngl_unmodeled | 10 | 0.030 | 0.049 | 202.094 | sngl_unmodeled | 100 | 0.040 | 0.106 | 946.316 | sngl_unmodeled | 1000 | 0.270 | 1.101 | 908.265 | sngl_dperiodic | 1 | 0.030 | 0.059 | 16.809 | sngl_dperiodic | 10 | 0.040 | 0.033 | 304.025 | sngl_dperiodic | 100 | 0.050 | 0.095 | 1048.691 | sngl_dperiodic | 1000 | 0.280 | 0.793 | 1261.503 | multi_inspiral | 1 | 0.030 | 0.053 | 19.047 | multi_inspiral | 10 | 0.030 | 0.043 | 231.685 | multi_inspiral | 100 | 0.060 | 0.264 | 379.200 | multi_inspiral | 1000 | 0.360 | 1.211 | 825.764 | multi_burst | 1 | 0.030 | 0.040 | 24.697 | multi_burst | 10 | 0.040 | 0.048 | 210.155 | multi_burst | 100 | 0.050 | 0.105 | 956.416 | multi_burst | 1000 | 0.270 | 0.748 | 1336.302 | frameset_loc | 1 | 0.010 | 0.020 | 49.176 | frameset_loc | 10 | 0.010 | 0.016 | 638.081 | frameset_loc | 100 | 0.020 | 0.066 | 1509.776 | frameset_loc | 1000 | 0.100 | 0.538 | 1858.684 | summ_value | 1 | 0.010 | 0.037 | 27.057 | summ_value | 10 | 0.020 | 0.025 | 396.637 | summ_value | 100 | 0.040 | 0.119 | 840.979 | summ_value | 1000 | 0.150 | 0.641 | 1560.523 | summ_statistics | 1 | 0.020 | 0.045 | 22.353 | summ_statistics | 10 | 0.020 | 0.030 | 331.851 | summ_statistics | 100 | 0.030 | 0.112 | 892.244 | summ_statistics | 1000 | 0.170 | 0.675 | 1482.026 | summ_spectrum | 1 | 0.010 | 0.057 | 17.607 | summ_spectrum | 10 | 0.010 | 0.074 | 134.474 | summ_spectrum | 100 | 0.040 | 0.447 | 223.663 | summ_spectrum | 1000 | 0.420 | 3.944 | 253.550 | summ_comment | 1 | 0.020 | 0.040 | 25.012 | summ_comment | 10 | 0.020 | 0.030 | 329.598 | summ_comment | 100 | 0.040 | 0.131 | 762.858 | summ_comment | 1000 | 0.280 | 0.904 | 1106.626 | summ_csd | 1 | 0.010 | 0.043 | 23.102 | summ_csd | 10 | 0.020 | 0.045 | 224.356 | summ_csd | 100 | 0.040 | 0.366 | 273.137 | summ_csd | 1000 | 0.300 | 3.195 | 312.989 | summ_mime | 1 | 0.020 | 0.048 | 20.696 | summ_mime | 10 | 0.020 | 0.053 | 189.854 | summ_mime | 100 | 0.070 | 0.389 | 257.317 | summ_mime | 1000 | 0.450 | 3.431 | 291.460 | sngl_unmodeled_v | 1 | 0.010 | 0.029 | 34.478 | sngl_unmodeled_v | 10 | 0.010 | 0.022 | 456.475 | sngl_unmodeled_v | 100 | 0.010 | 0.071 | 1413.448 | sngl_unmodeled_v | 1000 | 0.080 | 0.431 | 2320.498 | coinc_sngl | 1 | 0.050 | 0.119 | 8.392 | coinc_sngl | 10 | 0.050 | 0.095 | 105.412 | coinc_sngl | 100 | 0.110 | 0.243 | 412.317 | coinc_sngl | 1000 | 0.750 | 2.260 | 442.478 | sngl_transdata | 1 | 0.020 | 0.039 | 25.792 | sngl_transdata | 10 | 0.020 | 0.041 | 243.043 | sngl_transdata | 100 | 0.040 | 0.336 | 297.599 | sngl_transdata | 1000 | 0.310 | 2.799 | 357.270 | sngl_mime | 1 | 0.020 | 0.038 | 26.219 | sngl_mime | 10 | 0.010 | 0.047 | 211.278 | sngl_mime | 100 | 0.060 | 0.369 | 271.217 | sngl_mime | 1000 | 0.420 | 3.182 | 314.268 | sngl_datasource | 1 | 0.020 | 0.044 | 22.646 | sngl_datasource | 10 | 0.030 | 0.038 | 261.862 | sngl_datasource | 100 | 0.030 | 0.082 | 1225.490 | sngl_datasource | 1000 | 0.150 | 0.472 | 2119.569 |
|---|
Summary: