<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19267"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>Dear
All,</SPAN></DIV>
<DIV lang=EN-US vlink="purple" link="blue">
<DIV class=x_WordSection1>
<DIV>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>I <SPAN
class=131533721-11032019> am </SPAN>working <SPAN
class=131533721-11032019>on optimizing a MapServer /MapCache configuration of
</SPAN><SPAN class=131533721-11032019>a benchmark for creating <SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>MVT
tiles (seeding) of MapServer - versus T-Rex. </SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>This will
be featured in a presentation at the German FOSS4g ('FOSSGIS') 2019 in
Dresden at the end of this week. The whole thing is based on Pirmin Kalberer's
automated vector tile benchmark see - <A
href="http://blog.sourcepole.ch/2018/09/06/the-tale-of-a-vector-tile-benchmark/">http://blog.sourcepole.ch/2018/09/06/the-tale-of-a-vector-tile-benchmark/</A> .
Thus I created a similar configuration of the Natural Earth Data based world map
for MapServer (my favorite rendering engine !) to run it against T-REX.. Now
Pirmin has added this into the GitHUB repository as a 'MapServer' branch see -
<A
href="https://github.com/pka/mvt-benchmark/tree/mapserver">https://github.com/pka/mvt-benchmark/tree/mapserver</A></SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>Results of one of my first
trial benchmarks can be found here <A
href="https://github.com/karstenv/mvt-benchmark/tree/master/firsttests">https://github.com/karstenv/mvt-benchmark/tree/master/firsttests</A> .</SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>Unfortunately my favorite software (MapServer
/MapCache.fcgi) is falling pretty far behind in seeding speed in these tests
<BR></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>see e.g. in <SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><A
href="https://github.com/karstenv/mvt-benchmark/blob/master/firsttests/http.jpg">https://github.com/karstenv/mvt-benchmark/blob/master/firsttests/http.jpg</A></SPAN></SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>Thus, I wanted to call in the experts to find out
what configuration tweaks will help to increase the MapServer / Mapcache
performance.</SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>So far my next steps I will be </SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>working on
<BR>--------------------------------------------------------------------------------------------------<BR></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>1.) Setting the correct map file parameters to match
the T-Rex configuration for the FORMATOPTIONS <BR>"EXTENT"
and "EDGE_BUFFER" in the <SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>OUTPUTFORMAT<SPAN
class=131533721-11032019>
bloc.</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>OUTPUTFORMAT<SPAN
class=131533721-11032019> <BR></SPAN><SPAN
class=131533721-11032019> </SPAN>NAME "mvt"<SPAN
class=131533721-11032019> <BR></SPAN><SPAN
class=131533721-11032019> </SPAN>DRIVER MVT<SPAN
class=131533721-11032019> <BR></SPAN><SPAN
class=131533721-11032019> </SPAN>FORMATOPTION
"EXTENT=512" <SPAN lang=EN># default is 4096. # Comment by Pirmin for
t-rex this is 'tile_size' (per Layer): Width and height of the tile (Default:
4096. Grid default size is 256)<BR></SPAN><SPAN
class=131533721-11032019> </SPAN>FORMATOPTION
"EDGE_BUFFER=20"<SPAN class=131533721-11032019> # Comment by Pirmin
- seems to be the '<SPAN lang=EN>buffer_size' in mvtbench.toml , is set to
3 for the Country layer, for all others<BR></SPAN></SPAN>END<BR><BR>Any
suggestions wthat my best bet settings are in the map file is for
MapServer for "EXTENT" and "EDGE_BUFFER" ?</SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN
lang=EN>--------------------------------------------------------------------------------------------------<BR></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>2.) Tweaking the data statement of the
map file to match the T-Rex config <BR></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>So far I have e.g. for the countries
layer<BR><FONT color=#800000>DATA "wkb_geometry from (SELECT * FROM
ne_10m_admin_0_countries) as temp using unique ogc_fid using
SRID=3857"</FONT><BR></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>while T-Rex has<BR><FONT
color=#800000><SPAN class=pl-smi>sql</SPAN> = <SPAN class=pl-s><SPAN
class=pl-pds>"""</SPAN>SELECT wkb_geometry, adm0_a3, mapcolor7 FROM
ne_10m_admin_0_countries WHERE min_zoom::integer <= !zoom! AND wkb_geometry
&& !bbox!<SPAN class=pl-pds>"""</SPAN></SPAN></FONT>
<BR></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN>see <A
href="https://github.com/karstenv/mvt-benchmark/blob/master/t-rex/mvtbench.toml">https://github.com/karstenv/mvt-benchmark/blob/master/t-rex/mvtbench.toml</A><BR>I
am still trying to match the T-Rex statement above but did not come up with
a suitable comparable MapServer data statement so
far.<BR></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN><FONT color=#000000 size=3
face="Times New Roman"><FONT color=#000080 size=2 face=Arial><BR>Any suggestions
for this anyone
?<BR>--------------------------------------------------------------------------------------------------</FONT></FONT></SPAN></SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019><SPAN lang=EN></SPAN></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>3.) Does anyone have any other/
additional suggestions what else might help to increase MapServer
/MapCache performance ?</SPAN></SPAN></P></DIV>
<DIV>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>Thanks<SPAN
class=131533721-11032019> <BR></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'>Karsten<SPAN
class=131533721-11032019> </SPAN></SPAN></P>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>PS: </SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>The map file used is here <A
href="https://github.com/karstenv/mvt-benchmark/blob/master/MapServer/mapcache_mvt.xml">https://github.com/karstenv/mvt-benchmark/blob/master/MapServer/mapcache_mvt.xml</A>,<BR></SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'><SPAN
class=131533721-11032019>the MapCache config here <A
href="https://github.com/karstenv/mvt-benchmark/blob/master/MapServer/mapcache_mvt.xml">https://github.com/karstenv/mvt-benchmark/blob/master/MapServer/mapcache_mvt.xml</A> </SPAN></SPAN></P></DIV>
<DIV>
<P class=x_MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif; COLOR: navy'></SPAN> </P></DIV></DIV></DIV></BODY></HTML>