10/05/2009 - GeoServer ====================== (GeoServer contains all patches/workarounds developer for edges_merge in the same day) (aaime) shapefiles Label Count Avg Min Max Errors Throughput 1 100 89 59 230 0 10.9 10 200 381 61 1685 0 22.9 20 400 767 71 2847 0 23.0 40 800 1640 62 8945 0 22.0 postgis (192.168.0.8 oracle running) Label Count Avg Min Max Errors Throughput 1 100 92 58 276 0 10.6 10 200 351 60 1119 0 24.3 20 400 734 73 3342 0 23.3 40 800 1524 61 7931 0 23.4 Oracle Label Count Avg Min Max Errors Throughput 1 100 95 59 255 0 10.3 10 200 408 63 1743 0 21.2 20 400 777 75 7865 0 20.8 40 800 1440 63 17213 0 21.5 SDE Label Count Avg Min Max Errors Throughput 1 100 104 63 271 0 9.4 10 200 404 68 3126 0 19.6 20 400 813 88 5866 0 21.4 40 800 1695 73 16333 0 20.2 **************************************************************** 10/06/2009 - MapServer ===================== (jmckenna) ************************ shp_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 184 126 300 0 5.4 10 200 577 129 3866 0 14.7 20 400 1032 129 15623 0 15.1 40 800 1888 123 38157 0 15.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 152 118 200 0 6.5 10 200 557 126 9851 0 14.3 20 400 1089 131 13358 0 15.2 40 800 1991 123 31447 0 15.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 152 119 199 0 6.5 10 200 567 124 6063 0 15.1 20 400 1064 132 15976 0 15.3 40 800 2101 123 29593 0 15.5 ************************ pg_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 229 134 656 0 4.3 10 200 668 141 4387 0 12.4 20 400 1139 143 13087 0 14.8 40 800 2077 136 39941 0 15.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 168 130 287 0 5.9 10 200 593 138 4245 0 14.9 20 400 1100 147 16362 0 15.0 40 800 2208 135 32956 0 15.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 167 129 282 0 5.9 10 200 605 137 2123 0 14.5 20 400 1138 145 11131 0 15.1 40 800 2140 136 28967 0 15.2 ************************ oraclespatial_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 433 230 3744 0 2.3 10 200 1841 222 14747 0 4.5 20 400 2064 241 10027 0 9.0 40 800 2945 238 34502 0 12.1 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 267 217 523 0 3.7 10 200 758 245 1625 0 12.2 20 400 1411 257 9730 0 12.7 40 800 2661 323 25610 0 12.9 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 285 226 445 0 3.5 10 200 745 224 2011 0 12.2 20 400 1440 238 6022 0 12.7 40 800 2748 224 25338 0 12.6 ************************ oraclespatial_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 119 65 324 0 8.2 10 200 414 69 1503 0 21.8 20 400 838 79 2475 0 21.8 40 800 1431 80 3209 116 26.0 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 95 12 199 7 10.2 10 200 358 14 1435 20 23.2 20 400 656 42 2489 69 26.6 40 800 1391 14 5189 151 27.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 97 13 197 6 10.0 10 200 353 14 1742 21 24.0 20 400 691 14 2521 65 25.7 40 800 1400 14 7066 147 26.7 ************************ oracle_ogr_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1484 1310 6112 0 0.7 10 200 5679 1457 20820 0 1.6 20 400 11319 1435 26819 0 1.7 40 800 23043 1405 44372 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1390 1318 2236 0 0.7 10 200 5333 1356 26086 0 1.7 20 400 11179 1364 32809 0 1.7 40 800 23312 2088 50779 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1381 1318 1676 0 0.7 10 200 5389 1341 16694 0 1.7 20 400 11063 1340 43936 0 1.7 40 800 22700 1555 52384 0 1.7 ************************ sde_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 881 816 2045 0 1.1 10 200 1032 842 1362 0 9.3 20 400 1927 903 2318 2 10.0 40 800 3701 828 45939 2 8.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 868 824 977 0 1.1 10 200 1020 253 1384 2 9.4 20 400 1899 886 2425 0 10.1 40 800 3533 826 45870 2 9.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 864 821 967 0 1.2 10 200 1016 833 1373 0 9.4 20 400 1852 902 2458 1 10.4 40 800 3541 834 24888 0 9.9 ************************ sde_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 112 71 217 0 8.8 10 200 398 74 929 0 22.1 20 400 823 101 1430 0 22.5 40 800 1653 119 2444 0 23.0 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 110 70 210 0 8.8 10 200 406 74 801 0 22.0 20 400 815 91 1395 0 22.7 40 800 1678 120 2251 0 22.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 111 72 210 0 8.8 10 200 403 75 1078 0 22.2 20 400 811 97 1489 0 22.6 40 800 1653 116 2226 0 23.0 **************************************************************** 10/07/2009 - MapServer ===================== (jmckenna) ************************ shp_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 150 118 199 0 6.5 10 200 525 122 8600 0 14.9 20 400 1061 130 12920 0 14.9 40 800 2167 125 28295 0 15.5 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 151 119 199 0 6.5 10 200 527 125 8843 0 14.5 20 400 1052 151 18859 0 15.2 40 800 2127 122 36475 0 15.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 150 117 199 0 6.5 10 200 542 126 9841 0 14.5 20 400 1047 136 12930 0 15.4 40 800 2066 122 27326 0 15.4 ************************ pg_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 214 132 422 0 4.6 10 200 626 142 1898 0 14.2 20 400 1130 145 14611 0 14.9 40 800 2117 135 33976 0 15.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 167 131 282 0 5.9 10 200 597 139 2728 0 14.9 20 400 1112 146 14294 0 15.1 40 800 2155 139 29845 0 15.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 166 129 281 0 5.9 10 200 569 141 5494 0 14.7 20 400 1169 151 10542 0 15.1 40 800 2154 137 33411 0 15.3 ************************ pg_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 97 61 211 0 10.0 10 200 935 67 1291 0 10.0 20 400 1917 78 2509 0 9.9 40 800 3806 111 4479 0 10.1 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 97 61 216 0 10.0 10 200 935 66 1293 0 10.0 20 400 1913 87 2508 0 9.9 40 800 3812 112 4491 0 10.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 98 61 210 0 10.0 10 200 938 66 1297 0 9.9 20 400 1923 118 2509 0 9.9 40 800 3820 113 4485 0 10.1 ************************ oraclespatial_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 323 235 806 0 3.1 10 200 959 271 4661 0 9.7 20 400 1470 282 5059 0 12.4 40 800 2662 273 28541 0 12.9 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 261 217 358 0 3.8 10 200 737 236 2119 0 12.2 20 400 1421 257 6301 0 12.9 40 800 2617 236 31645 0 12.9 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 276 234 374 0 3.6 10 200 732 260 1887 0 12.6 20 400 1459 300 4897 0 12.7 40 800 2646 220 37876 0 12.9 ************************ oracle_ogr_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1406 1324 3451 0 0.7 10 200 5324 1408 22834 0 1.7 20 400 11059 1371 37498 0 1.7 40 800 22803 1359 43167 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1371 1310 1687 0 0.7 10 200 5557 1349 16560 0 1.7 20 400 11127 1372 38702 0 1.7 40 800 22640 1347 49145 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1379 1318 1668 0 0.7 10 200 5420 1361 18670 0 1.7 20 400 11541 1349 41314 0 1.6 40 800 22550 1393 47644 0 1.7 ************************ sde_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 876 817 2029 0 1.1 10 200 999 847 1278 0 9.5 20 400 1820 896 2331 1 10.6 40 800 3490 826 27251 2 10.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 863 822 962 0 1.2 10 200 992 842 1250 0 9.6 20 400 1839 914 2265 1 10.5 40 800 3549 827 48299 0 9.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 863 820 962 0 1.2 10 200 981 838 1373 0 9.7 20 400 1824 880 2149 2 10.5 40 800 3557 824 45900 1 8.5 ************************ sde_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 111 71 211 0 8.8 10 200 1053 76 1388 0 8.9 20 400 2156 88 2727 0 8.9 40 800 4261 119 4847 0 9.1 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 111 70 209 0 8.8 10 200 1056 75 1388 0 8.9 20 400 2159 122 2734 0 8.9 40 800 4257 122 4848 0 9.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 110 71 208 0 8.8 10 200 1054 75 1387 0 8.9 20 400 2148 104 2733 0 8.9 40 800 4256 120 4830 0 9.1 **************************************************************** 10/08/2009 - MapServer ===================== (jmckenna) ************************ shp_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 185 125 302 0 5.3 10 200 585 143 3296 0 14.9 20 400 1044 132 18414 0 15.1 40 800 2089 124 36207 0 15.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 151 119 202 0 6.5 10 200 554 133 7537 0 15.0 20 400 1147 133 12422 0 15.3 40 800 2133 127 36716 0 15.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 151 118 206 0 6.5 10 200 547 128 6555 0 14.9 20 400 1107 133 13689 0 15.3 40 800 2090 122 37875 0 15.5 ************************ pg_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 214 134 431 0 4.6 10 200 623 142 1458 0 14.2 20 400 1190 144 7914 0 15.0 40 800 2186 137 29007 0 15.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 167 131 284 0 5.9 10 200 568 136 3556 0 14.8 20 400 1196 146 8908 0 15.1 40 800 2236 146 33782 0 15.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 167 130 285 0 5.9 10 200 592 137 4533 0 14.6 20 400 1153 144 14146 0 14.8 40 800 2180 153 27736 0 15.3 ************************ pg_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 96 60 209 0 10.1 10 200 380 64 1060 0 23.2 20 400 758 90 1449 0 24.2 40 800 1552 92 2322 0 24.5 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 96 60 213 0 10.1 10 200 369 64 867 0 23.3 20 400 752 85 1370 0 24.2 40 800 1552 92 2345 0 24.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 96 60 210 0 10.1 10 200 369 65 1070 0 23.7 20 400 756 80 1566 0 24.2 40 800 1547 95 2466 0 24.5 ************************ oraclespatial_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 321 227 788 0 3.1 10 200 866 269 3392 0 10.4 20 400 1432 269 4662 0 12.5 40 800 2681 276 31704 0 12.9 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 265 215 363 0 3.7 10 200 729 237 2012 0 12.5 20 400 1430 252 8016 0 12.8 40 800 2699 233 25005 0 13.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 271 229 371 0 3.6 10 200 735 256 1602 0 12.4 20 400 1422 283 8897 0 12.8 40 800 2582 256 30925 0 13.0 ************************ oraclespatial_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 105 65 207 0 9.3 10 200 408 77 1093 0 21.7 20 400 843 91 1423 0 22.0 40 800 1714 105 2369 0 22.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 106 65 204 0 9.2 10 200 412 77 1226 0 21.1 20 400 848 110 1448 0 21.9 40 800 1719 132 2728 0 22.2 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 106 65 202 0 9.2 10 200 419 75 1406 0 21.1 20 400 864 153 1522 0 21.7 40 800 1738 140 2568 0 22.0 ************************ oracle_ogr_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1376 1305 1685 0 0.7 10 200 5677 1350 15807 0 1.7 20 400 11430 1850 34667 0 1.7 40 800 22808 1343 87061 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1366 1307 1666 0 0.7 10 200 5677 1335 13105 0 1.7 20 400 11174 1848 42041 0 1.7 40 800 22712 1929 67691 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1381 1310 1665 0 0.7 10 200 5330 1348 26110 0 1.7 20 400 10943 1318 35474 0 1.7 40 800 22495 1310 56718 0 1.7 ************************ sde_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 886 824 2696 0 1.1 10 200 1014 307 1416 1 9.2 20 400 1871 872 2334 1 10.3 40 800 3583 824 24758 2 10.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 864 821 964 0 1.2 10 200 988 228 1258 2 9.6 20 400 1851 890 2338 3 10.4 40 800 3543 829 24350 1 10.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 865 820 966 0 1.2 10 200 992 828 1285 0 9.6 20 400 1848 879 2358 2 10.4 40 800 3467 832 25034 1 10.2 ************************ sde_fcgi_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 111 70 212 0 8.8 10 200 388 75 1077 0 22.7 20 400 790 104 1489 0 23.2 40 800 1619 101 2324 0 23.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 110 70 210 0 8.9 10 200 385 74 1173 0 22.2 20 400 792 102 1373 0 23.1 40 800 1621 103 2617 0 23.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 110 70 214 0 8.9 10 200 386 75 961 0 22.3 20 400 785 110 1530 0 23.2 40 800 1612 114 2432 0 23.6 **************************************************************** 11/08/2009 - GeoServer ===================== (aaime) ************************ shp_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 88 58 216 0 11.1 10 200 369 62 2218 0 24.1 20 400 698 70 3377 0 24.4 40 800 1476 59 13304 0 23.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 88 57 255 0 11.1 10 200 354 59 1110 0 24.3 20 400 745 95 4137 0 24.0 40 800 1538 59 9321 0 22.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 88 57 261 0 11.0 10 200 367 59 1700 0 24.1 20 400 730 71 2753 0 23.8 40 800 1604 72 9327 0 22.6 ************************ pg_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 201 59 1020 0 4.9 10 200 529 63 8289 0 13.7 20 400 741 60 8551 0 22.1 40 800 1544 59 11361 0 23.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 91 56 309 0 10.7 10 200 356 60 1088 0 24.0 20 400 730 80 4511 0 24.3 40 800 1551 60 8970 0 23.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 89 56 186 0 10.9 10 200 363 60 1308 0 23.9 20 400 687 70 4221 0 24.7 40 800 1556 67 10918 0 23.3 ************************ oracle_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 147 62 587 0 6.7 10 200 815 68 10787 0 10.8 20 400 1169 62 9302 0 14.2 40 800 1498 71 20043 0 21.8 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 97 59 241 0 10.0 10 200 382 63 1586 0 22.8 20 400 798 72 7338 0 20.7 40 800 1399 62 18265 0 22.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 114 58 2170 0 8.6 10 200 369 61 2343 0 23.1 20 400 682 64 8147 0 22.2 40 800 1433 64 18213 0 21.9 ************************ sde_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 105 63 367 0 9.3 10 200 368 72 1383 0 22.8 20 400 729 77 7318 0 22.8 40 800 1587 77 20627 0 22.0 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 101 63 249 0 9.7 10 200 366 68 1654 0 23.1 20 400 742 76 4571 0 22.8 40 800 1579 68 21002 0 22.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 100 63 234 0 9.7 10 200 374 68 1246 0 22.7 20 400 750 90 3958 0 23.1 40 800 1572 66 20814 0 21.7 **************************************************************** 15/08/2009 - GeoServer ===================== (aaime) (SDE tests have been run the 16th) ************************ shp_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 89 57 173 0 10.9 10 200 464 60 3132 0 19.4 20 400 743 69 1431 0 24.4 40 800 1514 60 3138 0 25.1 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 88 56 257 0 11.1 10 200 349 61 2101 0 24.7 20 400 746 82 1965 0 24.4 40 800 1497 83 2279 0 25.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 88 56 280 0 11.0 10 200 349 59 1862 0 25.0 20 400 722 74 1638 0 25.2 40 800 1510 105 2883 0 25.1 ************************ pg_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 153 59 496 0 6.4 10 200 510 64 3584 0 17.2 20 400 793 80 2206 0 23.4 40 800 1506 76 2638 0 25.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 91 56 288 0 10.7 10 200 353 60 1002 0 24.4 20 400 744 72 1683 0 24.7 40 800 1484 98 2296 0 25.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 91 56 280 0 10.7 10 200 356 60 1149 0 24.4 20 400 725 80 1513 0 25.2 40 800 1478 74 2535 0 25.7 ************************ oracle_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 175 61 1551 0 5.6 10 200 989 70 14514 0 8.8 20 400 1377 83 6939 0 13.5 40 800 1711 84 5448 0 22.2 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 97 59 348 0 10.1 10 200 358 63 1718 0 23.5 20 400 774 77 1530 0 23.6 40 800 1558 64 3257 0 24.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 95 59 245 0 10.2 10 200 372 63 1498 0 23.1 20 400 767 73 1678 0 23.8 40 800 1659 91 3587 0 23.0 ************************ sde_areawater_merge ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 188 66 2398 0 5.2 10 200 957 70 12294 0 8.8 20 400 1246 84 5217 0 14.7 40 800 1743 85 6625 0 21.8 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 103 63 266 0 9.5 10 200 365 68 1097 0 23.3 20 400 769 79 1617 0 23.5 40 800 1576 98 2741 0 24.2 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 103 63 235 0 9.5 10 200 383 69 931 0 23.3 20 400 771 86 1436 0 23.6 40 800 1626 68 3313 0 23.3