<div dir="ltr">My experience with SQLite is that it is significantly slower than a disk based cache. My guess is this is related to how mapcache structures the transaction and inserts into the sqlitedb. It appears that the mapcache creates a transaction based on the <metatile> defined in the config, if the metatile is set to 5 5, mapcache will create a transaction with 25 inserts per process. Problems seem to arise when multiple threads / processes attempt to concurrently seed the cache and are backlogged / waiting due to a transaction in progress. Disk cache appear to be only limited based on disk io.</div><br><div class="gmail_quote"><div dir="ltr">On Wed, 17 Oct 2018 at 08:47, Sebastiano Laini <<a href="mailto:Sebastiano.Laini@buchanancomputing.co.uk">Sebastiano.Laini@buchanancomputing.co.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="m_-3958907768936341323WordSection1">
<p class="MsoNormal"><span style="color:#1f497d">This is my cache setup<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <cache name="cache_sqlite" type="sqlite3"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="color:#1f497d"><dbfile>/var/www/path…./maps/cache/{tileset}/{grid}/{z}/{x}-{y}.sqlite3</dbfile><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="color:#1f497d"><xcount>10000</xcount><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="color:#1f497d"><ycount>10000</ycount><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="color:#1f497d"><pragma name="max_page_count">1573741823</pragma><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> </cache><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <grid name="bcgrid"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <metadata><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <title>this is a custom grid I made up for an example</title><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> </metadata><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <srs>EPSG:27700</srs><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <size>128 128</size><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <extent>0 0 700000 1250000</extent><u></u><u></u></span></p>
<p class="MsoNormal" style="text-indent:36.0pt"><span style="color:#1f497d"><resolutions>70 28 14 7 6.16 2.8 1.4 0.7 0.28 0.14 0.07</resolutions><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"></grid><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <tileset name="bccache"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <source>bcmaps</source><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <cache>cache_sqlite</cache><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <grid>bcgrid</grid><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <format>JPEG</format><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <metatile>4 4</metatile><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <metabuffer>0</metabuffer><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <expires>31536000</expires><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> </tileset><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">227 Shepherds Bush Road London W6 7AS<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">020 8846 3220<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1f497d">Web:
<a href="http://www.buchanancomputing.co.uk/" target="_blank">http://www.BuchananComputing.co.uk</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1f497d">For general or urgent enquiries please write to:
</span><u><span style="font-size:9.0pt;color:#0563c1"><a href="mailto:support@BuchananComputing.co.uk" target="_blank">support@BuchananComputing.co.uk</a></span></u><span style="font-size:9.0pt;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1f497d">Buchanan Computing Ltd. Registered at the above office, no. 3274424 (England & Wales)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1f497d">This message is intended solely for the individual/entity to whom it is addressed. It may contain confidential or legally privileged information. Any unauthorised
disclosure or copying is prohibited and my be unlawful. If you have received this communication in error, please notify the sender immediately and delete it from your system.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Sebastiano Laini
<br>
<b>Sent:</b> 17 October 2018 13:39<br>
<b>To:</b> '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Cc:</b> 'Rahkonen Jukka (MML)' <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Subject:</b> RE: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">It appears in both ways, when I’m seeding and when is requested from a pre-seeded cache, today I can’t because I need to move the dev domain in another server but tomorrow I will pass you the link to the 2 cache
so you can see the difference.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Tonight I will let it seed the whole area.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">The cache is on a normal HDD, I think all out servers are 10000 RPM, and the test was done on a brand new server so the disk is new.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
</div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Rahkonen Jukka (MML) [<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">mailto:jukka.rahkonen@maanmittauslaitos.fi</a>]
<br>
<b>Sent:</b> 17 October 2018 13:35<br>
<b>To:</b> Sebastiano Laini <<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">Sebastiano.Laini@BuchananComputing.co.uk</a>>; '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> RE: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">In which way does the slowness appear? Is it when seeding or when serving from a pre-seeded cache? Can you give metrics about the difference in speed?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">In this comparison the differences were rather small
<a href="http://blog.sogeo.services/blog/2016/07/01/mapcache-disk-vs-sqlite.html" target="_blank">
http://blog.sogeo.services/blog/2016/07/01/mapcache-disk-vs-sqlite.html</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Also by the documentation the speed should be only “a bit slower”<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">The SQLite based caches are a bit slower than the disk based caches, and may have write-locking issues at seed time if a high number of threads all try to insert new tiles concurrently.<span style="color:#1f497d"><u></u><u></u></span></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">You wrote that SQLite cache is very slow for you which makes me think that there is something sub-optimal in your installation. First thing to check is if the SQLite database is on a fast disk.<br>
If SQLite cache is slow then MBTiles cache should be slow as well but I would make a test to be sure.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">-Jukka Rahkonen-<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FI">Lähettäjä:</span></b><span lang="FI"> Sebastiano Laini [<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">mailto:Sebastiano.Laini@BuchananComputing.co.uk</a>]
<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 15:00<br>
<b>Vastaanottaja:</b> '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Kopio:</b> Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Aihe:</b> RE: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="FI"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Is there a way to improve the speed and match the speed of the sqLite3 cache with the disk one?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">We have 80 websites connected to MapCache and when I tried the sqLite3 I was testing it just on one website and on a complete different server with nothing in it.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
</div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Sebastiano Laini
<br>
<b>Sent:</b> 17 October 2018 12:43<br>
<b>To:</b> '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Cc:</b> 'Rahkonen Jukka (MML)' <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Subject:</b> RE: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Still it redirect you to that link, and btw it seems that mapcache can be used also as a fastCGI.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><a href="https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions" target="_blank">https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Though is true that I’m reading now in the CMaker Builder section<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3e4349;background:white">MapCache can run as a FastCGI executable. Note that the overhead of FastCGI is non-negligible with respect to the throughput you may obtain with
a native Apache module. The FastCGI build is less tested, and may lag behind the Apache module version on some minor details. YMMV.</span><span style="color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Rahkonen Jukka (MML) [<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">mailto:jukka.rahkonen@maanmittauslaitos.fi</a>]
<br>
<b>Sent:</b> 17 October 2018 12:39<br>
<b>To:</b> Sebastiano Laini <<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">Sebastiano.Laini@BuchananComputing.co.uk</a>>; '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> VS: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="FI" style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="FI" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">That documentation is about Mapserver, Mapcache is another software. It does belong to the same Mapserver but is not the same.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">MapCache is documented here:<br>
<a href="https://mapserver.org/mapcache/index.html#mapcache" target="_blank">https://mapserver.org/mapcache/index.html#mapcache</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">-Jukka Rahkonen-<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FI">Lähettäjä:</span></b><span lang="FI"> Sebastiano Laini [<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">mailto:Sebastiano.Laini@BuchananComputing.co.uk</a>]
<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 14:33<br>
<b>Vastaanottaja:</b> '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Kopio:</b> Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Aihe:</b> RE: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="FI"><u></u> <u></u></span></p>
<p style="line-height:18.0pt;background:white"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3e4349">Well, for what I can read in the documentation of mapserver:<u></u><u></u></span></p>
<p style="line-height:18.0pt;background:white"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3e4349"><a href="https://mapserver.org/optimization/fastcgi.html" target="_blank">https://mapserver.org/optimization/fastcgi.html</a><u></u><u></u></span></p>
<p style="line-height:18.0pt;background:white"><span style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3e4349">FastCGI is a protocol for keeping cgi-bin style web applications running as a daemon to take advantage of preserving memory caches, and
amortizing other high startup costs (like heavy database connections) over many requests.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">It seems that using mapcache as fastCGI over apache modules it that should improve speed also.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Rahkonen Jukka (MML) [<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">mailto:jukka.rahkonen@maanmittauslaitos.fi</a>]
<br>
<b>Sent:</b> 17 October 2018 12:30<br>
<b>To:</b> Sebastiano Laini <<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">Sebastiano.Laini@BuchananComputing.co.uk</a>>; '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="FI" style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="FI" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Could you explain your plan with some more details? What I have understood is that you have experienced that SQLite cache is slower than disk cache in your environment.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">What I do not understand is what you are going to reach by running Mapcache as fastcgi instead of running it as Apache module which should be the faster option, and if this has some connection with
the SQLite cache vs. disk cache comparison. Do you guess that fastcgi woud make SQLite cache faster?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">-Jukka Rahkonen-<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FI">Lähettäjä:</span></b><span lang="FI"> mapserver-users [<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Sebastiano Laini<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 12:16<br>
<b>Vastaanottaja:</b> '<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>' <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Aihe:</b> [mapserver-users] mapcache fastcgi<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="FI"><u></u> <u></u></span></p>
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">In the end I tried MapCache with sqlite3 cache but it’s very slow compared with the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I don’t understand what I need to install as the fastCGI link in the documentation is broken and I don’t know if is up to date.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I already have apache fgcid installed from default in the httpd folder and I use PHP in fastCGI in all the domains, so I’m sure that fastCGI it works, though, I still need the fastCGI library? How can I install it in CentOS 7?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">In my apache conf I’ve already added the lines to load the mapcache module and the mapcache.xml file<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">LoadModule mapcache_module modules/mod_mapcache.so<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><IfModule mapcache_module><u></u><u></u></p>
<p class="MsoNormal"> <Directory /path/to/directory><u></u><u></u></p>
<p class="MsoNormal"> Require all granted<u></u><u></u></p>
<p class="MsoNormal"> </Directory><u></u><u></u></p>
<p class="MsoNormal"> MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"<u></u><u></u></p>
<p class="MsoNormal"></IfModule><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I need to leave the previous configuration and add these new lines in the conf files?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><IfModule mod_fcgid.c><u></u><u></u></p>
<p class="MsoNormal"> IPCCommTimeout 120<u></u><u></u></p>
<p class="MsoNormal"> MaxProcessCount 10<u></u><u></u></p>
<p class="MsoNormal"> FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"<u></u><u></u></p>
<p class="MsoNormal"> <Location /map.fcgi><u></u><u></u></p>
<p class="MsoNormal"> Order Allow,Deny<u></u><u></u></p>
<p class="MsoNormal"> Allow from all<u></u><u></u></p>
<p class="MsoNormal"> SetHandler fcgid-script<u></u><u></u></p>
<p class="MsoNormal"> </Location><u></u><u></u></p>
<p class="MsoNormal"> ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"<u></u><u></u></p>
<p class="MsoNormal"></IfModule><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">And then instead of <a href="http://myserver/mapcache" target="_blank">http://myserver/mapcache</a> I need to use
<a href="http://myserver/fcgi-bin" target="_blank">http://myserver/fcgi-bin</a> to access mapcache fcgi?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Sebastiano Laini<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Web Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Buchanan Computing<u></u><u></u></span></p>
</div>
</div>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></blockquote></div>