I should have done some tests, but haven't had time that yet. I feel that we have gained performance both in seeding and access. But I haven't done any measurements.
My first goal was to have sqlite db files that were not to big and not to small. It worked really good serving 16 zoom levels over the Nordic countries. I guess this could be fine tuned even more. /Lars Schylberg September 20, 2018 3:18 PM, "Travis Kirstine" <[email protected] (mailto:[email protected]?to=%22Travis%20Kirstine%22%20<[email protected]>)> wrote: Lars, Sorry for the side questions Is there any performance benefit (specifically seeding) in using the x/ycount parameters? Thanks On Thu, 20 Sep 2018 at 08:24, <[email protected] (mailto:[email protected])> wrote: I also ran into the problem of running out of i-nodes last year. Here is the configuration I have with a sqlite cache: <cache name="Nordic_sqlite" type="sqlite3"> <dbfile>/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3</dbfile> <xcount>10000</xcount> <ycount>10000</ycount> <pragma name="max_page_count">1573741823</pragma> </cache> I guess the pragma thing is described in the documentation. xcount and ycount describes how much You want to store in each sqlite db file before it creates a new db file. mapcache is creating the db files automatically. So seeding a large area You end up with many sqlite db files that all work together. This has worked really good for our use case. Lars Schylberg September 20, 2018 1:24 PM, "Yves Jacolin" <[email protected] (mailto:[email protected]?to=%22yves%20jacolin%22%20%[email protected]%3E)> wrote: Here a short tuto from my personal notes: 1. create a cache entry in your mapcache file <cache name="mbtiles" type="sqlite3"> <dbfile>/var/www/osm_google.db</dbfile> </cache> 2. create a empty sqlite file - run sqlite3 - run this commande inside sqlite3: ".save filename.db" (without ") 3. use this cache in your settings 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:/.... Y. Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <[email protected] (mailto:[email protected])> a écrit : Hi all, 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. 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. 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. Regards; Sebastiano. _______________________________________________ mapserver-users mailing list [email protected] (mailto:[email protected]) https://lists.osgeo.org/mailman/listinfo/mapserver-users (https://lists.osgeo.org/mailman/listinfo/mapserver-users) -- Training and support manager Camptocamp Bâtiment le Dauphin - 1er étage 18 rue du Lac Saint André 73382 Le Bourget-du Lac Tel (France) : +33 4 58 48 20 43 Tel (Switzerland) : +41 21 619 10 43 Mob. : +33 6 18 75 42 21 email : [email protected] (mailto:[email protected]) http://www.camptocamp.com (http://www.camptocamp.com) _______________________________________________ mapserver-users mailing list [email protected] (mailto:[email protected]) https://lists.osgeo.org/mailman/listinfo/mapserver-users (https://lists.osgeo.org/mailman/listinfo/mapserver-users)
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
