<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body><div data-html-editor-font-wrapper="true" style="font-family: arial, sans-serif; font-size: 13px;">I should have done some tests, but haven't had time that yet.<br>I feel that we have gained performance both in seeding and access.<br>But I haven't done any measurements. <br><br>My first goal was to have sqlite db files that were not to big and not to small.<br>It worked really good serving 16 zoom levels over the Nordic countries.<br><br>I guess this could be fine tuned even more.<br><br>/Lars Schylberg<br><br><br>September 20, 2018 3:18 PM, "Travis Kirstine" <<a target="_blank" tabindex="-1" href="mailto:traviskirstine@gmail.com?to=%22Travis%20Kirstine%22%20<traviskirstine@gmail.com>">traviskirstine@gmail.com</a>> wrote:<br> <blockquote><div><div> <div dir="ltr">Lars,<div>Sorry for the side questions</div> <div></div> <div>Is there any performance benefit (specifically seeding) in using the x/ycount parameters?</div> <div></div> <div>Thanks</div> </div> <div> <div dir="ltr">On Thu, 20 Sep 2018 at 08:24, <<a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="mailto:lars.schylberg@blixtmail.se">lars.schylberg@blixtmail.se</a>> wrote:</div> <blockquote style="margin: 0 0 0 .8ex;border-left: 1px #ccc solid;padding-left: 1ex"> <div><div style="font-family: arial,sans-serif;font-size: 13px">I also ran into the problem of running out of i-nodes last year.<br><br>Here is the configuration I have with a sqlite cache:<br><br><cache name="Nordic_sqlite" type="sqlite3"><br><dbfile>/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3</dbfile><br><xcount>10000</xcount><br><ycount>10000</ycount><br><pragma name="max_page_count">1573741823</pragma><br></cache><br><br>I guess the pragma thing is described in the documentation.<br>xcount and ycount describes how much You want to store in each sqlite db file before it creates a new db file.<br>mapcache is creating the db files automatically. So seeding a large area You end up with many sqlite db files that all work together.<br><br>This has worked really good for our use case.<br><br>Lars Schylberg<br><br><br>September 20, 2018 1:24 PM, "Yves Jacolin" <<a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="mailto:yves.jacolin@camptocamp.com?to=%22Yves%20Jacolin%22%20%3Cyves.jacolin@camptocamp.com%3E">yves.jacolin@camptocamp.com</a>> wrote:<blockquote><div><div><div dir="ltr"> <div>Here a short tuto from my personal notes:</div> <div></div> <div>1. create a cache entry in your mapcache file</div> <div><pre><code> <cache name="mbtiles" type="<span>sqlite3</span>"> <dbfile>/var/www/osm_google.db</dbfile> </cache> </code></pre></div> <div>2. create a empty sqlite file</div> <div>- run sqlite3</div> <div>- run this commande inside sqlite3: ".save filename.db" (without ")</div> <div>3. use this cache in your settings</div> <div></div> <div>You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path used in my example for cache block are for Unix like system, you should adapt it for Windows : c:/....</div> <div></div> <div>Y.</div> <div></div> <div> <div dir="ltr">Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <<a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="mailto:Sebastiano.Laini@buchanancomputing.co.uk">Sebastiano.Laini@buchanancomputing.co.uk</a>> a écrit :</div> <blockquote style="margin: 0 0 0 .8ex;border-left: 1px #ccc solid;padding-left: 1ex"> <div link="#0563C1" vlink="#954F72" lang="EN-GB"><div> <p>Hi all,</p> <p>We have a MapCache setup with “disk_cache” but we are running out of Inodes when I try to seed the whole UK with projection 27700.</p> <p>I was thinking to propose to my supervisor to use the “SQLite Caches” but I don’t know how it works. Can someone guide me through the process of setup MapCache with this type of cache? And if I need some dependency, we use PostgreSQL in our server so I assume I need to install also MySQL.</p> <p>I’ve already read the documentation but still I have doubt about the db part, how to create the db and locate it. I never use SQLite, just PostgreSQL.</p> <p>Regards;</p> <p>Sebastiano.</p> </div></div>_______________________________________________<br>mapserver-users mailing list<br><a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a> </blockquote> </div> <br clear="all"><br>--<div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Training and support manager<br>Camptocamp<br>Bâtiment le Dauphin - 1er étage<br>18 rue du Lac Saint André<br>73382 Le Bourget-du Lac<br><br>Tel (France) : +33 4 58 48 20 43<br>Tel (Switzerland) : +41 21 619 10 43<br>Mob. : +33 6 18 75 42 21<br><br>email : <a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="mailto:yves.jacolin@camptocamp.com">yves.jacolin@camptocamp.com</a><br><a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="http://www.camptocamp.com">http://www.camptocamp.com</a> </div></div></div></div></div></div></div></div></div></div></div> </div></div></div></blockquote> <br> </div></div>_______________________________________________<br>mapserver-users mailing list<br><a target="_blank" rel="external nofollow noopener noreferrer" tabindex="-1" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a rel="external nofollow noopener noreferrer" target="_blank" tabindex="-1" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a> </blockquote> </div> </div></div></blockquote> <br><br><signature></signature> </div></body></html>