10-06-2009 GeoServer ==================== (aaime, quickly... it's late...) shapefiles Label Count Avg Min Max Errors Throughput 1 100 90 60 221 0 10.8 10 200 343 63 2631 0 23.4 20 400 783 76 2998 0 22.7 40 800 1625 64 5345 0 22.1 postgis Label Count Avg Min Max Errors Throughput 1 100 91 58 259 0 10.6 10 200 357 63 1220 0 24.4 20 400 706 72 3972 0 24.5 40 800 1601 63 5571 0 22.7 oracle Label Count Avg Min Max Errors Throughput 1 100 92 61 241 0 10.5 10 200 357 65 2278 0 23.0 20 400 764 77 7109 0 21.7 40 800 1315 66 18782 0 23.6 sde Label Count Avg Min Max Errors Throughput 1 100 98 64 217 0 10.0 10 200 371 69 948 0 23.3 20 400 748 77 3421 0 23.2 40 800 1612 69 10370 0 22.5 **************************************************************** 10/06/2009 - MapServer ===================== (jmckenna) ************************ shp_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 170 118 298 0 5.8 10 200 561 126 3588 0 15.1 20 400 1017 136 18793 0 15.0 40 800 1873 123 34689 0 15.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 151 118 202 0 6.5 10 200 544 122 7491 0 15.0 20 400 1050 127 19909 0 15.3 40 800 1984 124 36766 0 15.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 150 117 201 0 6.6 10 200 541 124 10346 0 14.2 20 400 1065 131 15700 0 15.4 40 800 2056 125 32331 0 15.6 ************************ pg_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 276 132 1080 0 3.6 10 200 589 133 2093 0 14.7 20 400 1134 150 12095 0 15.3 40 800 2174 139 32715 0 15.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 161 128 212 0 6.1 10 200 594 134 2935 0 15.0 20 400 1094 146 13090 0 15.3 40 800 2014 134 35027 0 15.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 161 130 213 0 6.1 10 200 582 132 5025 0 15.2 20 400 1126 150 11585 0 15.2 40 800 2138 134 40042 0 15.5 ************************ oraclespatial_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 384 220 4134 0 2.6 10 200 720 229 1768 0 12.9 20 400 1398 256 5208 0 13.2 40 800 2544 242 30568 0 13.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 279 237 473 0 3.5 10 200 732 253 1564 0 12.6 20 400 1386 240 6374 0 12.8 40 800 2526 222 30737 0 13.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 268 214 451 0 3.7 10 200 730 241 1370 0 12.8 20 400 1385 261 4926 0 13.3 40 800 2602 240 29933 0 13.4 ************************ oraclespatial_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 76 12 180 25 12.7 10 200 97 13 325 148 68.0 20 400 209 12 438 308 73.7 40 800 443 16 751 622 78.8 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 75 12 153 25 12.8 10 200 103 12 326 145 61.1 20 400 206 14 436 312 76.1 40 800 437 17 746 623 79.9 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 75 12 150 25 12.8 10 200 98 13 305 147 64.4 20 400 201 13 549 315 75.9 40 800 438 15 758 621 79.0 ************************ oracle_ogr_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1372 1300 1519 0 0.7 10 200 5459 1338 19171 0 1.7 20 400 11033 1333 29733 0 1.7 40 800 22598 1318 46904 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1362 1317 1507 0 0.7 10 200 5411 1374 24331 0 1.7 20 400 11291 1414 27486 0 1.7 40 800 22962 1392 53959 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1362 1306 1492 0 0.7 10 200 5423 1359 23961 0 1.7 20 400 10964 1366 32055 0 1.7 40 800 22498 1342 44442 0 1.7 ************************ sde_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 860 817 1309 0 1.2 10 200 955 831 1139 0 10.0 20 400 1803 902 2169 1 10.7 40 800 3436 824 93908 1 6.5 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 856 819 919 0 1.2 10 200 949 330 1100 1 10.0 20 400 1828 923 2210 1 10.5 40 800 3516 285 26210 1 10.2 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 856 816 911 0 1.2 10 200 964 243 1153 1 9.9 20 400 1807 893 2037 1 10.7 40 800 3464 825 93845 1 6.7 ************************ sde_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 102 69 167 0 9.5 10 200 946 76 1138 0 9.9 20 400 1935 137 2292 0 9.8 40 800 3871 126 4327 0 10.0 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 102 69 159 0 9.5 10 200 948 73 1141 0 9.9 20 400 1943 89 2295 0 9.8 40 800 3871 127 4320 0 10.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 102 69 159 0 9.5 10 200 948 72 1140 0 9.9 20 400 1936 136 2295 0 9.8 40 800 3871 126 4318 0 10.0 **************************************************************** 10/07/2009 - MapServer ===================== (jmckenna) ************************ shp_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 170 120 306 0 5.8 10 200 570 129 7014 0 15.2 20 400 1043 129 18453 0 15.3 40 800 2105 125 31031 0 15.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 149 116 201 0 6.6 10 200 513 121 8438 0 15.1 20 400 1089 128 15968 0 15.1 40 800 2083 124 32599 0 15.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 149 117 202 0 6.6 10 200 508 125 8519 0 14.9 20 400 1040 131 19269 0 15.5 40 800 1995 137 32726 0 15.7 ************************ pg_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 193 134 334 0 5.1 10 200 588 133 1995 0 15.3 20 400 1111 141 11781 0 15.2 40 800 2044 136 33738 0 15.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 161 129 214 0 6.1 10 200 543 133 7940 0 14.7 20 400 1120 144 12852 0 15.2 40 800 2046 136 29093 0 15.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 160 128 212 0 6.1 10 200 582 136 2197 0 15.1 20 400 1075 146 10170 0 15.4 40 800 2043 138 29376 0 15.6 ************************ pg_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 92 59 154 0 10.6 10 200 832 65 1015 0 11.2 20 400 1686 96 1983 0 11.2 40 800 3391 114 3823 0 11.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 91 60 145 0 10.6 10 200 829 64 1016 0 11.2 20 400 1688 104 1983 0 11.2 40 800 3389 115 3821 0 11.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 91 60 144 0 10.7 10 200 830 70 1017 0 11.2 20 400 1698 79 2003 0 11.2 40 800 3928 114 4751 0 9.8 ************************ oraclespatial_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 285 212 677 0 3.5 10 200 711 232 1400 0 13.0 20 400 1378 243 5390 0 13.4 40 800 2505 230 37170 0 13.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 266 230 310 0 3.7 10 200 700 251 1348 0 13.1 20 400 1337 261 9897 0 13.1 40 800 2741 221 25782 0 12.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 258 221 305 0 3.8 10 200 711 244 1770 0 13.1 20 400 1363 253 10160 0 13.2 40 800 2593 261 28808 0 12.9 ************************ oracle_ogr_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1364 1303 1634 0 0.7 10 200 5421 1317 22667 0 1.7 20 400 11147 1361 32954 0 1.7 40 800 22528 1702 49895 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1344 1304 1408 0 0.7 10 200 5229 1373 23748 0 1.7 20 400 10992 1326 36647 0 1.7 40 800 22301 1303 43313 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1352 1312 1414 0 0.7 10 200 5523 1366 18063 0 1.7 20 400 11223 1359 30765 0 1.7 40 800 22489 1338 64023 0 1.7 ************************ sde_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 860 815 1308 0 1.2 10 200 978 307 1287 2 9.5 20 400 1770 890 2102 1 10.8 40 800 3450 772 45884 3 8.9 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 855 818 911 0 1.2 10 200 960 827 1100 0 9.9 20 400 1784 870 2066 2 10.8 40 800 3511 828 24080 1 10.2 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 855 821 924 0 1.2 10 200 960 832 1166 0 9.9 20 400 1780 862 2086 0 10.8 40 800 3445 825 24185 1 10.3 ************************ sde_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 137 92 226 0 7.1 10 200 1301 100 1596 0 7.3 20 400 2698 161 3736 0 7.1 40 800 2508 162 5714 0 15.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 118 67 213 0 8.3 10 200 543 72 749 0 16.8 20 400 1122 114 1755 0 16.7 40 800 2390 85 5350 1 16.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 119 69 213 0 8.2 10 200 539 73 708 0 16.9 20 400 1121 92 1720 0 16.7 40 800 2237 103 2570 0 17.1 **************************************************************** 10/08/2009 - MapServer ===================== (jmckenna) ************************ shp_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 171 119 344 0 5.7 10 200 551 127 7354 0 14.9 20 400 1039 134 16648 0 15.3 40 800 2131 127 35634 0 15.5 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 153 118 204 0 6.4 10 200 478 121 8153 0 15.0 20 400 1044 131 18380 0 15.4 40 800 1995 123 35561 0 15.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 150 117 202 0 6.6 10 200 516 125 8560 0 14.9 20 400 1048 136 17199 0 15.3 40 800 2120 123 31029 0 15.7 ************************ pg_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 193 134 381 0 5.1 10 200 578 135 3714 0 15.1 20 400 1092 148 14036 0 15.2 40 800 2137 135 32843 0 15.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 161 130 213 0 6.1 10 200 588 134 3559 0 15.0 20 400 1073 152 16146 0 15.3 40 800 2114 136 27610 0 15.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 161 130 216 0 6.1 10 200 571 135 4109 0 15.0 20 400 1136 139 15978 0 15.0 40 800 2151 138 29398 0 15.5 ************************ pg_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 91 59 150 0 10.7 10 200 367 62 777 0 24.4 20 400 749 117 1282 0 24.6 40 800 1526 94 2861 0 25.0 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 90 59 144 0 10.8 10 200 365 63 704 0 24.2 20 400 755 90 1371 0 24.5 40 800 1522 148 2117 0 25.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 90 59 146 0 10.8 10 200 366 64 728 0 24.3 20 400 747 98 1308 0 24.6 40 800 1524 101 2789 0 25.0 ************************ oraclespatial_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 296 236 578 0 3.3 10 200 720 243 1890 0 12.8 20 400 1379 279 6825 0 13.2 40 800 2450 220 35662 0 13.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 253 218 301 0 3.9 10 200 711 234 1321 0 12.9 20 400 1364 244 5237 0 13.1 40 800 2778 251 27913 0 12.6 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 271 213 319 0 3.7 10 200 714 216 1946 0 12.7 20 400 1352 239 8372 0 13.3 40 800 2481 219 29776 0 13.4 ************************ oraclespatial_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 101 64 180 0 9.7 10 200 373 67 797 0 23.3 20 400 784 91 1688 0 23.4 40 800 1595 99 2159 0 23.9 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 99 64 156 0 9.8 10 200 383 68 1046 0 23.1 20 400 786 144 1390 0 23.5 40 800 1592 128 2092 0 24.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 99 65 157 0 9.8 10 200 387 68 885 0 23.3 20 400 788 95 1399 0 23.4 40 800 1590 107 2125 0 23.9 ************************ oracle_ogr_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 1347 1306 1407 0 0.7 10 200 5575 1336 14624 0 1.7 20 400 10919 1478 38912 0 1.7 40 800 22534 1514 50762 0 1.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 1344 1301 1424 0 0.7 10 200 5255 1316 21016 0 1.7 20 400 10996 1325 40570 0 1.7 40 800 22481 1366 54550 0 1.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 1354 1290 1668 0 0.7 10 200 5288 1306 20990 0 1.7 20 400 11016 1493 30550 0 1.7 40 800 22427 1310 44476 0 1.7 ************************ sde_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 861 816 1377 0 1.2 10 200 966 839 1168 0 9.9 20 400 1793 895 2116 1 10.7 40 800 3535 828 24190 3 10.3 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 855 818 909 0 1.2 10 200 965 829 1093 0 9.9 20 400 1798 898 2052 2 10.7 40 800 3502 825 24119 1 10.2 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 854 817 909 0 1.2 10 200 964 836 1099 0 9.9 20 400 1782 883 2018 0 10.8 40 800 3591 825 45903 0 8.6 ************************ sde_fcgi_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 102 68 160 0 9.5 10 200 372 72 761 0 23.7 20 400 772 144 1459 0 24.0 40 800 1560 107 2458 0 24.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 102 68 165 0 9.6 10 200 375 73 751 0 23.2 20 400 776 100 1528 0 23.8 40 800 1557 100 2217 0 24.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 101 69 156 0 9.6 10 200 374 72 822 0 23.6 20 400 771 96 1558 0 23.9 40 800 1558 107 2083 0 24.5 **************************************************************** 11/08/2009 - GeoServer ===================== (aaime) ************************ shp_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 88 57 211 0 11.0 10 200 352 62 2455 0 23.4 20 400 699 74 4062 0 24.0 40 800 1543 83 6009 0 22.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 89 57 232 0 10.9 10 200 351 60 1553 0 24.0 20 400 838 73 4501 0 20.9 40 800 1598 63 5777 0 22.3 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 90 56 249 0 10.8 10 200 358 61 1770 0 24.0 20 400 743 77 1993 0 23.9 40 800 1566 63 6613 0 22.3 ************************ pg_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 220 61 986 0 4.5 10 200 383 60 1861 0 23.1 20 400 822 72 3865 0 21.7 40 800 1393 72 6741 0 24.7 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 89 56 238 0 11.0 10 200 352 61 1634 0 24.5 20 400 830 89 3109 0 22.0 40 800 1447 63 5576 0 23.1 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 88 57 211 0 11.0 10 200 343 61 1319 0 24.8 20 400 708 72 3895 0 24.3 40 800 1490 61 8712 0 23.4 ************************ oracle_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 120 61 286 0 8.1 10 200 347 64 1591 0 24.0 20 400 727 77 7317 0 23.7 40 800 1412 65 17700 0 22.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 92 59 241 0 10.6 10 200 359 64 1261 0 24.1 20 400 702 71 3786 0 23.9 40 800 1394 66 20578 0 22.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 93 61 269 0 10.4 10 200 357 64 1108 0 24.6 20 400 683 76 5133 0 24.3 40 800 1455 65 19146 0 22.1 ************************ sde_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 99 63 303 0 9.8 10 200 361 71 979 0 24.5 20 400 814 93 3962 0 21.4 40 800 1411 84 6688 0 24.5 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 96 62 291 0 10.2 10 200 360 67 996 0 24.3 20 400 843 90 3760 0 21.4 40 800 1486 68 6589 0 22.9 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 95 62 239 0 10.3 10 200 388 67 1053 0 23.2 20 400 751 81 2927 0 23.9 40 800 1528 76 7065 0 23.0 15/08/2009 - GeoServer ===================== (aaime) The SDE results have been collected the 16th ************************ shp_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 216 58 2590 0 4.6 10 200 401 61 2927 0 19.7 20 400 735 80 2721 0 24.5 40 800 1508 74 3249 0 25.1 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 89 57 214 0 10.9 10 200 356 62 1703 0 23.8 20 400 735 73 1913 0 24.4 40 800 1536 63 3579 0 24.7 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 105 57 1876 0 9.3 10 200 365 61 3197 0 24.3 20 400 730 85 2593 0 25.0 40 800 1504 76 3576 0 25.2 ************************ pg_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 121 61 381 0 8.1 10 200 354 61 1442 0 24.1 20 400 731 82 1184 0 25.2 40 800 1475 106 2745 0 25.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 88 56 238 0 11.0 10 200 418 61 3406 0 20.9 20 400 721 78 1328 0 25.5 40 800 1463 73 1997 0 26.0 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 88 56 208 0 11.0 10 200 352 61 1319 0 25.1 20 400 724 84 1277 0 25.3 40 800 1473 72 2237 0 25.8 ************************ oracle_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 122 64 545 0 8.0 10 200 371 69 1042 0 24.0 20 400 740 80 1316 0 24.8 40 800 1499 76 2315 0 25.4 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 92 60 263 0 10.5 10 200 436 64 2719 0 20.6 20 400 725 103 1341 0 25.5 40 800 1500 84 2253 0 25.4 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 92 58 256 0 10.5 10 200 353 64 981 0 25.0 20 400 724 86 1425 0 25.2 40 800 1542 85 3354 0 24.6 ************************ sde_gnis_names09 ************************ ******** RUN 1 ******** Label Count Avg Min Max Errors Throughput 1 100 252 68 2755 0 3.9 10 200 446 75 1447 0 19.6 20 400 757 104 1267 0 24.0 40 800 1546 100 2313 0 24.6 ******** RUN 2 ******** Label Count Avg Min Max Errors Throughput 1 100 95 63 251 0 10.2 10 200 375 67 750 0 23.9 20 400 756 86 1336 0 24.4 40 800 1556 120 2185 0 24.5 ******** RUN 3 ******** Label Count Avg Min Max Errors Throughput 1 100 96 63 238 0 10.1 10 200 351 67 782 0 24.5 20 400 748 100 1263 0 24.6 40 800 1587 127 3150 0 23.9